Need Help on Matching a value from a list of values

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
 
J

JE McGimpsey

One way:

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


another:

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

CLR

Possibly........

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

Vaya con Dios,
Chuck, CABGx3
 
H

Harlan Grove

CLR said:
Possibly........

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

Or

=IF(COUNTIF(Data!B2:B21,K54),"Zone2","Zone1")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match data then comapre and return new data 0
Sub to write another result dimension into comments over formula c 5
Drop down list control value in vba 2
Auto worksheet name? 1
Calculate the median value before a specified list 0
find time and text 1
If or 3
Return Value in Cell Diagonally opposite 1

Top