Sorting and Matching Columns in Excel
Closed
jchapman1964
-
11 Mar 2010 à 06:22
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Mar 2010 à 10:42
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Mar 2010 à 10:42
Related:
- Sorting and Matching Columns in Excel
- Excel mod apk for pc - Download - Spreadsheets
- Sorting bookmarks in chrome - Guide
- Arrow keys not working in excel - Guide
- Excel column number - Guide
- Vat calculation excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 Mar 2010 à 10:42
11 Mar 2010 à 10:42
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