Excell Function-Compare a Cell to a Column of Names to return a value

  • Thread starter Thread starter jbadman
  • Start date Start date
J

jbadman

I am trying to compare a cell with a name in it to a column with a lis
of names in it. If the name is found I want it to put in
result(text) into another cell. If the name is not in the column
want it to compare it to another column and again return a resul
(text) if the name is not in the second column, I want excell to put i
a defult result (text). I tried using an IF function, but I can no
get it to work
 
One way, assuming value to be looked up is in A1 and ranges being looked in are
C1:C10 and E1:E10

=IF(NOT(ISNA(MATCH(A1,C1:C10,0))),"1st
Col",IF(NOT(ISNA(MATCH(A1,E1:E10,0))),"2nd Col","Not There"))
 
Just another way

=CHOOSE((COUNTIF(C1:C10,A1)+COUNTIF(E1:E10,A1)*2+1),"Not There","1st Col","2nd
Col")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Ken Wright said:
One way, assuming value to be looked up is in A1 and ranges being looked in are
C1:C10 and E1:E10

=IF(NOT(ISNA(MATCH(A1,C1:C10,0))),"1st
Col",IF(NOT(ISNA(MATCH(A1,E1:E10,0))),"2nd Col","Not There"))
Click to expand...
 
Back
Top