LinkBack URL
About LinkBacks
I'm trying to get a formula that basically says "If the result of my VLOOKUP contains text then return an "x" if it doesnt then leave the cell blank"
Any thoughts?
I'm trying to get a formula that basically says "If the result of my VLOOKUP contains text then return an "x" if it doesnt then leave the cell blank"
Any thoughts?
Iferror((vlookup(A1,D:E,2,false),"")
see enclosed file
Try this formula
=IF(ISNUMBER(VLOOKUP(A2,$D$2:$E$4,2,0)),"","X")
In B2
Lookup X X
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks