C
CherylH
I need to do the following:
(1) Lookup the values in Worksheet #1, Column G,
(2) FIND the SAME value in Worksheet #2, Column E
(3) RETURN the Value from Worksheet #2, Column B (on the same row where the
lookup value was found in Worksheet #2, Column E
Worksheet #1, Column G
Apples
Worksheet #2
Col B Column E
ABC Apples
I want to see the value of "ABC", which corresponds to my value that was
within Column E.
Any help would surely be appreciated! Thanks all and Happy New Year!
Cheryl
(1) Lookup the values in Worksheet #1, Column G,
(2) FIND the SAME value in Worksheet #2, Column E
(3) RETURN the Value from Worksheet #2, Column B (on the same row where the
lookup value was found in Worksheet #2, Column E
Worksheet #1, Column G
Apples
Worksheet #2
Col B Column E
ABC Apples
I want to see the value of "ABC", which corresponds to my value that was
within Column E.
Any help would surely be appreciated! Thanks all and Happy New Year!
Cheryl