Match

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),"")

--
HTH

Bob Phillips

"Alessandra Tessitore" <[email protected]> wrote in message
news:BEF825CF.1855%[email protected]...
> 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!
>

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))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Alessandra Tessitore" <[email protected]> wrote in message
news:BEF825CF.1855%[email protected]...
> 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!
>