Comparing data among excel sheets
Closed
Da Chef
-
Aug 29, 2016 at 03:14 AM
TrowaD
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Comparing data among excel sheets
- How to transfer data between excel sheets - Guide
- Auto populate data between Excel sheets ✓ - Forum - Excel
- Comparing Data in Excel ✓ - Forum - Excel
- Copy data one excel sheet to other sheet ✓ - Forum - Excel
- Compare two Excel sheets: and combine data - Guide
1 reply
TrowaD
Sep 1, 2016 at 11:34 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Sep 1, 2016 at 11:34 AM
Hi Da Chef,
Try looking into the VLOOKUP formula. It will look for a given value (product number) in a given range and returns the value from a specified column in the range.
When nothing is found, it will produce an error. Use this to get a result from all 3 sheet by using a combination of IF and ISERROR together with VLOOKUP.
Best regards,
Trowa
Try looking into the VLOOKUP formula. It will look for a given value (product number) in a given range and returns the value from a specified column in the range.
When nothing is found, it will produce an error. Use this to get a result from all 3 sheet by using a combination of IF and ISERROR together with VLOOKUP.
Best regards,
Trowa