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
- Tweetdeck larger columns - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - 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