Returning the result of a vlookup in the same cell
 

Hi all Excel Fans
I am working on a spreadsheet that somebody previously set up and I don't
know how he has done something.
It seems to me that he has used a vlookup formula, but the result is in the
same cell as the item being 'looked up', i.e. the lookup value.
There are more questions, but they can wait :) for now
Stuckie

Returning the result of a vlookup in the same cell
 

Post the formula

"Stuckie" wrote:

Hi all Excel Fans
I am working on a spreadsheet that somebody previously set up and I don't
know how he has done something.
It seems to me that he has used a vlookup formula, but the result is in the
same cell as the item being 'looked up', i.e. the lookup value.
There are more questions, but they can wait :) for now
Stuckie