View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default =IF, If only I knew the answer

On Sun, 10 Jun 2012 02:34:08 +0000, markd038 wrote:

Hi all,
I'm trying to come up with the correct function to check if the text in
cell in an adjacent cell matches a value from a list of possible values.
And if it does, return a value from another list of possible values.
Does that make Sense????


Yes, but you don't want a bunch of nested IFs, you want VLOOKUP or
HLOOKUP.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...