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

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

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

Works OK for me.

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

Goto InsertNameDefine
Select Extract
Delete
OK

Then your VLOOKUP formula should work:

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

--
Biff
Microsoft Excel MVP


"Mr. Low" wrote in message
...
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

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

Hi Biff,

Thanks for the tip.

Best Regards

Low
--
A36B58K641


"Mr. Low" wrote:

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

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Mr. Low" wrote in message
...
Hi Biff,

Thanks for the tip.

Best Regards

Low
--
A36B58K641


"Mr. Low" wrote:

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