R
Rui Gomes
I' using a CELL function within a VLOOKUP funtion, but the returned value
came between quotation marks:
VLOOKUP(G13;CELL("contents";H5);2;FALSE)
CELL("contents";H5) contains a table range name.
How can I put the CELL returned value without the double quotation marks?
--------- " ----------
ADSE = $B$2:$E$960
CELL("contents";H5) = ADSE
I want - VLOOKUP(G13;ADSE;2;FALSE)
I get VLOOKUP(G13;"ADSE";2;FALSE)
Thank you
Best regards
Rui Gomes
came between quotation marks:
VLOOKUP(G13;CELL("contents";H5);2;FALSE)
CELL("contents";H5) contains a table range name.
How can I put the CELL returned value without the double quotation marks?
--------- " ----------
ADSE = $B$2:$E$960
CELL("contents";H5) = ADSE
I want - VLOOKUP(G13;ADSE;2;FALSE)
I get VLOOKUP(G13;"ADSE";2;FALSE)
Thank you
Best regards
Rui Gomes