VLOOKUP referencing table name

[ioncila]

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]

Is "Table2" a defined name?

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

[ioncila]

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]

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