Comparing data among excel sheets

Closed
Da Chef - Aug 29, 2016 at 03:14 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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


Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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