Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ?

[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

 

[T. Valko]

Works OK for me.

Excel creates the named range "Extract" when you do the filter operation.
You can just delete that defined name.

Goto Insert>Name>Define
Select Extract
Delete
OK

Then your VLOOKUP formula should work:

=VLOOKUP (A10,B$4:C$8,2,FALSE)

 

[Mr. Low]

Hi Biff,

Thanks for the tip.

Best Regards

Low

 

[T. Valko]

You're welcome. Thanks for the feedback!