Sorting and Matching Columns in Excel
Closed
jchapman1964
-
Mar 11, 2010 at 06:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 10:42 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 10:42 AM
Related:
- Sorting and Matching Columns in Excel
- Number to words in excel - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
- How to sort bookmarks in chrome - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 11, 2010 at 10:42 AM
Mar 11, 2010 at 10:42 AM
Not sure exactly what you want
Lets say you want to see in last year status, how you are doing this year.
Assumption
Data on sheet1 starts at row 2
Column D in sheet 1 is available
In D2 write
=IF(ISERROR(VLOOKUP(A2, Sheet2!A:B, 2, FALSE)), "", VLOOKUP(A2, Sheet2!A:B, 2, FALSE))
Drag this formula to the last line
Lets say you want to see in last year status, how you are doing this year.
Assumption
Data on sheet1 starts at row 2
Column D in sheet 1 is available
In D2 write
=IF(ISERROR(VLOOKUP(A2, Sheet2!A:B, 2, FALSE)), "", VLOOKUP(A2, Sheet2!A:B, 2, FALSE))
Drag this formula to the last line