Need Help on Matching a value from a list of values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nespa - 09 Jul 2004 05:48 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

JE McGimpsey - 09 Jul 2004 06:02 GMT

One way:

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

another:

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

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

Reply to this Message

CLR - 09 Jul 2004 13:33 GMT

Possibly........

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

Vaya con Dios,
Chuck, CABGx3

> This is my formula: =IF(Data!B2:B21=K54,"ZONE2","ZONE1") and k54=PINEL
> AND PINEL is found IN THE RANGE B2:B21 ;however, this fromula returns
[quoted text clipped - 6 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Harlan Grove - 09 Jul 2004 13:43 GMT

"CLR" <croberts@hitechled.com> wrote...

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

...

Or

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

Reply to this Message