Is there a way to do a VLOOKUP in which if the value is found display TRUE in Excel and FALSE in Excel?
Thanks.
Is there a way to do a VLOOKUP in which if the value is found display TRUE in Excel and FALSE in Excel?
Thanks.
Something like this will do it:
=IF(ISNA(VLOOKUP(E2,$A$4:$B$10,2,FALSE)),FALSE,TRUE)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Or leave out the IF and just use...
=ISNA(VLOOKUP("dd",D2:E13,1,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks