Need Help on Matching a value from a list of values

  • Thread starter Thread starter nespa
  • Start date Start date
N

nespa

This is my formula: =IF(Data!B2:B21=K54,"ZONE2","ZONE1") and k54=PINE
AND PINEL is found IN THE RANGE B2:B21 ;however, this fromula return
ZONE1

Can some one help me?

Thank
 
One way:

=IF(ISNA(MATCH(K54,Data!B2:B21,FALSE)),"ZONE1","ZONE2")


another:

=IF(COUNTIF(Data!B2:B21,K54),"ZONE2","ZONE1")
 
Possibly........

=IF(ISNA(VLOOKUP(K54,Data!B2:B21,1,FALSE)=TRUE),"Zone1","Zone2")

Vaya con Dios,
Chuck, CABGx3
 
Back
Top