Comparing columns and returning value
Closed
surajkumarraju
Posts
1
Registration date
Tuesday 12 October 2010
Status
Member
Last seen
12 October 2010
-
12 Oct 2010 à 09:25
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Oct 2010 à 10:38
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Oct 2010 à 10:38
Related:
- Comparing columns and returning value
- Beyond and compare - Download - File management
- How to delete columns in word - Guide
- How to merge and compare two excel files - Guide
- Excel drop down list multiple columns - Guide
- Excel columns as numbers - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
14 Oct 2010 à 10:38
14 Oct 2010 à 10:38
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