Copy values if a match against a range of value is found

Wallaby

New member
Joined
Mar 19, 2015
Messages
3
Reaction score
0
Points
0
If each of the values in A is found to have a match anywhere in the list in D, I should like the values in B and C to be copies out to the right in E and F (against the particular value).
Appreciate your help, thank you.
Example:
CA77noOH
FL12yesFL
MA7yesNY
NC3yesNH
NH68noCA
NY5yesCA
OH32noNY
OK12noMA
OH
NY
CA
 
E1:
=VLOOKUP(D1,$A$1:$C$8,2,FALSE)

F1:
=VLOOKUP(D1,$A$1:$C$8,3,FALSE)

copy down.
 
Back
Top