vlookups

[lfrick]

I am new to excel 2007. I am taking it on live through a local college. Any
way, I am try to put it a range

=VLOOKUP("ProductPrice[[#Headers],[Type]]",ProductPrice,ProductPrice[ID],FALSE)
and I keep getting an error message. I can't figure out what is wrong with it.

 

[Niek Otten]

Please explain what your data layout is and what you are trying to do.

 

[Shane Devenshire]

Hi,

You need to look up VLOOKUP in the Help system. Your formula should look
more like

=VLOOKUP(T2,Table_Query_from_Northwind_2007,9,FALSE)

The 3 argument should be the column number you want returned, the first
argument probably should not be within the lookup table. [Type] is probably
a field in the table not the whole table.

 

[T. Valko]

=VLOOKUP("ProductPrice[[#Headers],[Type]]",ProductPrice,ProductPrice[ID],FALSE)

Personally, I don't see how anyone could like those structured references in
formulas. Just looking at your formula I have no idea what you're looking up
or where it might be located. On the other hand, if your formula was
something like this:

=VLOOKUP(A1,Sales2009!A,4,0)

I can look at that formula and tell exactly what you're looking up and where
it's located. Another problem with the structured reference syntax is that
you can't use absolute referencing without a kludge, the use of INDIRECT.
And then that makes the formula volatile which may not be a good thing.