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

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
 
T

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top