Comparing data among excel sheets

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

I have three excel sheets with data regarding product numbers and their respective plants as well as another sheet (4th sheet) which is a total of all the data on the other three sheeets. The total sheet has about 2000 rows but there are 99 product numbers and their required plants missing from the total sheet. how do i find the missing data?
thanks


1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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