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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - actual value not the formula
If x99 is the cell that contains A6, you can use this formula:
=indirect(x99) to show the value in A6. 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - actual value not the formula
Hi
Try =INDIRECT(C3) where C3 holds your formula which concatenates A and 6 to give A6 -- Regards Roger Govier "rexmann" wrote in message ... 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 __________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - actual value not the formula
Yes there is.
Use the INDIRECT function in the cell which gets the address: =INDIRECT(<your current function) This will return the value referenced by your text function. If this helps, please click "Yes" <<<<<<<<<< "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 | |||
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 |