Hi,

I use Advance Filter to get unique reference in a table by output it to
A10: A16 :

A B
10 XB12 =VLOOKUP (A10,B$4:C$8,2,FALSE)
11 LH24 =VLOOKUP (Extract,B$4:C$8,2,FALSE)
12 NB47
13 VB45
14 NP96
15 TR45
16 MN32

After that I would like to search data for column A reference from table
B4:C8,

However I could not enter formula=VLOOKUP (A10,B$4:C$8,2,FALSE) at B10, The
word "Extract" is replacing the lookup cell A10 instead.

May I know why and how to overcome this problem ?

Thanks

Low
--
A36B58K641