Nested If and Or fxn for multiple cells

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

Thanks so much. It didn't exactly work like a charm, but I will do more more tweaking and see if I can come up with something. I may have to actually post the file for you to have a looksee.


Cll