Comparing data among excel sheets
[Closed]
Report
Da Chef
-
TrowaD
TrowaD
- Posts
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
Related:
- Comparing data among excel sheets
- Compare data in two excel sheets - How-To - Excel
- Comparing data between two excel sheets ✓ - Forum - Excel
- Compare data between two excel sheets ✓ - Forum - Excel
- How to pull data from one excel sheet into another automatically - How-To - Excel
- How to get data from one excel sheet to another automatically ✓ - Forum - Excel
1 reply
TrowaD
- Posts
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
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
