View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Refewrence tables

I have a set of values in column A, and 4 reference columns C, D, and E. I
want to reference column A to find a matching value in either column C,D or E
and return a value of the column the match was found in. For example in
column A row 2 the value is "jackson" I want excell to look in column C, D
and E and if "jackson" is found in column D, then return the value D.

The formula will be located in column B.

Is this possible? I am stumped.