If I have a text value in A1-A5 (cell merged and wrapped) how can I do a lookup for corresponding value in any cells B1-B5?
Maybe an if statement too?.
What I want it to do is if specific text is in A-A5, I want it to report the number in B1-B5, the number could be in any of those cells, but those cells are not merged.
Hope it makes sense.
Maybe an if statement too?.
What I want it to do is if specific text is in A-A5, I want it to report the number in B1-B5, the number could be in any of those cells, but those cells are not merged.
Hope it makes sense.
