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 Contributor Last seen December 27, 2022 - Oct 14, 2010 at 10:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Oct 14, 2010 at 10:38 AM
Related:
- Comparing columns and returning value
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete columns in word - Guide
- Excel columns changed to numbers - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
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