# if vlookup yields no results then try another vlookup

1. ## if vlookup yields no results then try another vlookup

I need some help with some nested formulas. I've got too many nests and I'm mixing them up.

So in the attached data sheet you'll see three chunks of data. I've simplified this dramatically from what I'm actually working with.

Goal -
If item from data set 1 is in either column 1 or 2 of "compared with this data set" then return "true" in to "data set evaluated" area
if item from data set 1 is not in EITHER column 1 or column 2 of "compared with this data set" then return value "false" in to "data set evaluated" area
additionally the tables I'm working in from data set 1 come in varying length in terms of number of rows. If there are fewer rows in data set 1 then I just want the cell to be blank (I don't a big "N/A" error there)

I tried several different if(iserror(isblank(vlookup(vlookup)))) combinations - not in that specific order - to yield a result with no luck.

2. ## Re: if vlookup yields no results then try another vlookup

Try this in A13 filled right/down to B20

=IF(A2="","",COUNTIF(\$I\$3:\$J\$9,A2)>0)

3. ## Re: if vlookup yields no results then try another vlookup

FYI,
Originally Posted by IronCladRooster
I've simplified this dramatically from what I'm actually working with.
That's usually not a good idea.
Solutions to the 'simplified' version of a problem are often not applicable to the actual version.

4. ## Re: if vlookup yields no results then try another vlookup

Not sure I understand completely but...

In A13:
=IFERROR(not(ISERROR(VLOOKUP(I3,Table2[Data Set 1],1,0))),ISERROR(VLOOKUP(I3,Table2[Column1],1,0)))

In B13
=IFERROR(not(ISERROR(VLOOKUP(J3,Table2[Data Set 1],1,0))),ISERROR(VLOOKUP(J3,Table2[Column1],1,0)))

?

5. ## Re: if vlookup yields no results then try another vlookup

Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.

If you explain your problem better I can solve it for you. Enter some expected output, that will make it easier to understand what you want.

6. ## Re: if vlookup yields no results then try another vlookup

Originally Posted by Jacc
Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
I'm putting that in my sig.

7. ## Re: if vlookup yields no results then try another vlookup

''''''''''''''

8. ## Re: if vlookup yields no results then try another vlookup

''''''''''''''

9. ## Re: if vlookup yields no results then try another vlookup

I want to quote each of the posts in this thread because they're all gems.

Thanks for your help. The formula results solved the problem.
Sorry for not being very clear with my question in the first place.
Thanks for the laugh Jacc!

10. ## Re: if vlookup yields no results then try another vlookup

You're welcome.

11. ## Re: if vlookup yields no results then try another vlookup

So what was the solution?
Edit: Or rather which formula solved your problem?

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1