Comparing data among excel sheets

Closed
Da Chef - Aug 29, 2016 at 03:14 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Sep 1, 2016 at 11:34 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
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
0