Comparing columns and returning value
Closed
surajkumarraju
Posts
1
Registration date
Tuesday October 12, 2010
Status
Member
Last seen
October 12, 2010
-
Oct 12, 2010 at 09:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 14, 2010 at 10:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 14, 2010 at 10:38 AM
Related:
- Comparing columns and returning value
- Display two columns in data validation list but return only one - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- If two cells match return value from third excel ✓ - Excel Forum
- Use the ifs function to return 5 if cell a5 contains the value 3, and return a 6 if it contains any other number. - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 14, 2010 at 10:38 AM
Oct 14, 2010 at 10:38 AM
Hi Suraj,
A condition for VLOOKUP is that the value that you want to look up is in the left most column of the table you want to look in. So you will need to rearrange your data. You can also get creative and make up column C the same as column A and and then hide column C or change the textcolor to white.
To get a 0 instead of an error message use this formula structure:
=IF(ISERROR(VLOOKUP(A1,sheet1!A1:B6,2)),0,VLOOKUP(A1,sheet1!A1:B6,2))
Best regards,
Trowa
A condition for VLOOKUP is that the value that you want to look up is in the left most column of the table you want to look in. So you will need to rearrange your data. You can also get creative and make up column C the same as column A and and then hide column C or change the textcolor to white.
To get a 0 instead of an error message use this formula structure:
=IF(ISERROR(VLOOKUP(A1,sheet1!A1:B6,2)),0,VLOOKUP(A1,sheet1!A1:B6,2))
Best regards,
Trowa