Hi Guys,
I'm trying to find a cell in an entire column that equals a cell that I know the location of. For example, let's say I'm writing =IF(A2=B:B, A2,"Cell not found") on cell C2. The problem with this statement is that the logic tries to match cell A2 with an entire array B:B, and what I wanna do is find the cell in B:B that is equal to A2 and then output it on cell C2. Does anyone have an idea on how to do this?
Thanks a lot.
Best,
Alexander Bazzi
CCNA, MCP, A+
Bookmarks