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

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

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

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

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