View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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