Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - value not formula
Hi
I have an issue with a vlookup and the returned value. I have a vlookup which according to the dropdown returns a cell column reference (such as A or D). Next another cell takes this value and adds the cell row number (such A and 6) to create the value A6. I want the cell to display the contents of A6 as in a link =A6 but the cell is actually a formula so it displays the text A6. Is there away a formula will just read the value of the cell and not the formula. Any help greatly appreciated (or a more detailed explanation can be given) Kind regards Rexmann PS Using Excel 2007 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - value not formula
Use INDIRECT. In that cell which returns the concat "A6", try something like
this instead: =INDIRECT(vlookup(..)&formula_rownum) Any good? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "rexmann" wrote: I have an issue with a vlookup and the returned value. I have a vlookup which according to the dropdown returns a cell column reference (such as A or D). Next another cell takes this value and adds the cell row number (such A and 6) to create the value A6. I want the cell to display the contents of A6 as in a link =A6 but the cell is actually a formula so it displays the text A6. Is there away a formula will just read the value of the cell and not the formula. Any help greatly appreciated (or a more detailed explanation can be given) Kind regards Rexmann PS Using Excel 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine a VLOOKUP formula and a NETWORKDAYS formula? | Excel Worksheet Functions | |||
Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Using VLOOKUP formula | Excel Discussion (Misc queries) | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) |