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.  Register To Reply

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)  Register To Reply

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.  Register To Reply

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)))

?  Register To Reply

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.  Register To Reply

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.  Register To Reply

7. ## Re: if vlookup yields no results then try another vlookup ''''''''''''''  Register To Reply

8. ## Re: if vlookup yields no results then try another vlookup ''''''''''''''  Register To Reply

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!  Register To Reply

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

You're welcome.  Register To Reply

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

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

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