I am using a VLOOKUP
=IFERROR(VLOOKUP($C$1,Patrons!$A$1:$J$500,3,FALSE),"")
What I would like to do is if Cell C1 has the word "All" it would cancel the lookup process and just display a blank cell.
A name will selected in C1, but if the name selected is "All" the response will need to be blank.
I appreciate any help.
Thank you,
Nick
Bookmarks