How to compare two excel worksheets.
Closed
RAO UV
-
Jul 12, 2010 at 10:00 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 13, 2010 at 08:08 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 13, 2010 at 08:08 AM
Related:
- How to compare two excel worksheets.
- Transfer data from one excel worksheet to another automatically - Guide
- Beyond compare - Download - File management
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 13, 2010 at 08:08 AM
Jul 13, 2010 at 08:08 AM
Use function VLOOKUP
=VLOOKUP(B2, 'FILE 1'!B:C, 2, False)
This is saying
Look at the value in cell B2
Compare this b2 value in Column B of FIle1
when the match is found give me the second column value in range B:C (which would be C)
and false is saying, I want an exact match
In case there might be missing matches you can have
=IF(ISERROR(VLOOKUP(B2, 'FILE 1'!B:C, 2, False)), "",VLOOKUP(B2, 'FILE 1'!B:C, 2, False))
=VLOOKUP(B2, 'FILE 1'!B:C, 2, False)
This is saying
Look at the value in cell B2
Compare this b2 value in Column B of FIle1
when the match is found give me the second column value in range B:C (which would be C)
and false is saying, I want an exact match
In case there might be missing matches you can have
=IF(ISERROR(VLOOKUP(B2, 'FILE 1'!B:C, 2, False)), "",VLOOKUP(B2, 'FILE 1'!B:C, 2, False))
