PDA

View Full Version : VLOOKUP referencing table name



ioncila
10-15-2014, 03:54 AM
Hi
I have this formula that should work:
=VLOOKUP(c4,Table2,5,False) - Table2 is located in sheet2
I have tried too:
=VLOOKUP(c4,Table2[[#Headers],[Products]],False)
But I always get #N/A
What am I dooing wrong?
Thanks in advance
Ioncila

SamT
10-15-2014, 06:51 AM
Is "Table2" a defined name?

Alternately, instead of typing "Table2" into the formula, select the entire Table2.

ioncila
10-15-2014, 07:07 AM
Hi
Table2 is a referencing table - I guess it as called table name (excel2013).
But it's a table that "grows" everyday, so if I select the table range, will it assume the new data too in the range?

ioncila
10-15-2014, 09:57 AM
I Think I've solved with INDEX & MATCH
=INDEX(Table2[[#Data],[Products]],MATCH(C4,Table2[[#Data],[Clients]],0))
But I still can't figure why VLOOKUP doesn't work