M
Mr. Low
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
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