I want to do a vlookup, but only return values if a match is found AND it isn't equal to a certain value. Can I do this with a Vlookup or some other function? Or would it require me to write a macro?
Thanks in advance,
Katy
Hi Katy and welcome to the forum.
I think, that you do not need VBA for this.
Would you like to upload a small sample workbook?
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Hi Katy, could you please title your thread with an outline of your issue? This makes it easy for other people searching the forum to find the answers they need.
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Hi Katy
take a look at the attached, perhaps this is what you are looking for?
the first formula will only return a value if its result does not equal a value in the third column
the second example will only return a value if its result does not equal a fixed value
HTH
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks