I want to create a message that would appear in cell a2, if and only if the text "N/A" appears in the range X22:AB40. If "N/A" does not appear then A2 is to be blank.
I have been playing with Vlookup to do this, but cannot get it to do exactly what I want... any thoughts?
Bookmarks