Without reading the whole thread, it kind of sounds like there should be an
exact match:

=IF(ISNUMBER(MATCH(O2,SHEET2!A2:A190)),"AB","CD")
should be
=IF(ISNUMBER(MATCH(O2,SHEET2!A2:A190,0)),"AB","CD" )

(and extra ",0" in the formula)

Bob Phillips wrote:

=IF(ISNUMBER(MATCH(O2,SHEET2!A2:A190)),"AB","CD")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"monkeydan" wrote
in message ...

OK, disregard the two questions above as I'm now aware you can't format
cells to that degree using conditional formatting (although please feel
free to enlighten me if I'm incorrect!)

However, I now have another question...

I have a list of postcodes which correspond to a certain value (AB).

If cell O2 contains one of the postcodes in the list (on sheet 2), I
want cell AN to display 'AB'. If the postcode in O2 does not appear on
the list, I want cell AN to display "CD"

At the moment, I've got this formula in cell AN2...

=IF(O2=SHEET2!A2:A190),"AB","CD")

But everything is returning CD, regardless of whether cell O2 contains
a postcode within A2:A190 or not.

Can anyone help?!


--
monkeydan
------------------------------------------------------------------------
monkeydan's Profile:
http://www.excelforum.com/member.php...o&userid=36982
View this thread: http://www.excelforum.com/showthread...hreadid=567038


--

Dave Peterson