So let me just start off by thanking anyone who responds. Also, if this requires VBA, I know a bit but not as much as I'd like.

The conundrum (simplified - in reality Columns contain about 2000 rows):

(A1:A5) are all integers
(B1:B5) are all integers
(C1:C5) are all text

I want to create an IF function that looks at a single cell in Column B and checks all the cells in Column A for that same number. I want the true test to render cells Bx:Cx (x=row number) and the false test to render "none"

In my mind this worked:

=IF(A1=OR(A1:A5), B1:C1, "none")

However, Excel wasn't buying it.

Thanks again for the help. Cll