Thread
:
CELL return value without double quotation marks
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
CELL return value without double quotation marks
Try it like this:
=VLOOKUP(G13;INDIRECT(H5);2;FALSE)
I'm assuming that the named range is a *static* range.
--
Biff
Microsoft Excel MVP
"Rui Gomes" <Rui
wrote in message
...
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
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko