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
Bookmarks