Pivot value not formula

R

rexmann

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
 
R

rexmann

Apologies, for double post (see above), problem with hotmail account

Cheers Rexmann
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup - value not formula 1
Vlookup - actual value not the formula 3
Pivot Value not formula 4
Formula to check presence of value between sheets 7
Search cell value in same column 3
Help with a pop-up msg 5
MATCH formula 10
SUMPRODUCT returns #VALUE error 2

Top