Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot 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
|
|||
|
|||
Pivot value not formula
Apologies, for double post (see above), problem with hotmail account
Cheers Rexmann "rexmann" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot formula | Excel Discussion (Misc queries) | |||
pivot formula | Excel Discussion (Misc queries) | |||
Pivot Formula | Excel Discussion (Misc queries) | |||
cancelling getpivot formula when setting formula outside pivot ta. | Excel Worksheet Functions | |||
deactivate the get pivot formula when I link a cell to a pivot | New Users to Excel |