HLookup/Needing Formula Question
Sheet 1
A B C D
1 Location Item Qty. Lot#
2 001a Apples 23 5998
3 002a Oranges 41 6335
4 003a Lemons 27 1448
5 004a Grapes 10 2889
Sheet 2
A B C
1 Location Item Qty. Lot#
2 002a Oranges 41 6335
I am trying to figure out a formula that will find data in a row and give back the word, "True" if all data is in that row in Sheet 2 from Sheet1. Can anyone help?
Above is just an example. With this example, let's assume that I am trying to find the info in Sheet 2 row 1.
|