| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CELL return value without double quotation marks
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add quotation marks to each cell in a column | Excel Discussion (Misc queries) | |||
| Quotation Marks? | Excel Worksheet Functions | |||
| without quotation marks? | Excel Discussion (Misc queries) | |||
| Quotation Marks - When and What?? | Excel Discussion (Misc queries) | |||
| quotation marks | Excel Worksheet Functions | |||
Linear Mode
