Match

  • Thread starter Thread starter Alessandra Tessitore
  • Start date Start date
A

Alessandra Tessitore

I have 2 sheets:
the 1st contains 2 columns as follows

A B
io tu
ei ae
ze ro
wa sw
qu kl


the 2nd contains 1 column which shows only a part of data listed in A in the
1st sheet

D
ei
wa
qu

Does it exist a function that allows to select and retrieve in the 1st sheet
all data reported in the 2nd sheet?

i.e. results:

A B
ei ae
wa sw
qu kl

Many thanks!
 
=IF(NOT(ISNA(VLOOKUP(A2,Sheet1!$A$1:$B$100,2,False))),VLOOKUP(A2,Sheet1!$A$1
:$B$100,2,False),"")
 
In Sheet2, with the lookup values in A1 down,
Put in B1: =VLOOKUP(A1,Sheet1!A:B,2,0)
Copy down

Alternatively, with an error-trap to return blanks: "" instead of #N/As for
unmatched cases, you could put in B1, and copy down:
=IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,0)),"",VLOOKUP(A1,Sheet1!A:B,2,0))
 
Back
Top