Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Value not formula
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 PS Using Excel 2007 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Value not formula
is this you are looking ?
=INDIRECT("A"&6) On Oct 19, 1:36*pm, Simmeh 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 PS Using Excel 2007 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Value not formula
No prob.
Use the INDIRECT formula to achieve what you want: =INDRIECT(<your formula to give A6) If this helps please click "Yes" <<<<<<<<<<< "Simmeh" 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 PS Using Excel 2007 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Value not formula
Yes, just what I wanted - cheers rexmann/Simmeh
"BSc Chem Eng Rick" wrote: No prob. Use the INDIRECT formula to achieve what you want: =INDRIECT(<your formula to give A6) If this helps please click "Yes" <<<<<<<<<<< "Simmeh" 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 PS Using Excel 2007 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Value not formula
Glad to help.
If posts help, please click "Yes" so that others know that questions have been answered and can benefit as well. "rexmann" wrote: Yes, just what I wanted - cheers rexmann/Simmeh "BSc Chem Eng Rick" wrote: No prob. Use the INDIRECT formula to achieve what you want: =INDRIECT(<your formula to give A6) If this helps please click "Yes" <<<<<<<<<<< "Simmeh" 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 PS Using Excel 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot value not 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 |