| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - actual value not the 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the formula displaying rather than the actual value? | Excel Worksheet Functions | |||
| Add the actual value in a cell that contains a formula | Excel Discussion (Misc queries) | |||
| what is the 1 minus in this formula actual doing | Excel Worksheet Functions | |||
| Vlookup: returning the value below the actual row | Excel Discussion (Misc queries) | |||
| Linking or Vlookup actual values | New Users to Excel | |||
Threaded Mode
