Nesting VLOOKUP Within and IF

[Blakerid]

Hello,

I am trying to Nest an Vlookup within and IF statement to return a "YES" if the value is in another table. I would also like it to return "NO" if the value is not in the table.

With the formula I have now it will pull the "YES" if the value is in the table but it will not pull the "NO" if the data isn't present.
Instead of "NO" it keeps giving me an #NA error.

Any help is appreciated.

Here is the formula I have been using.

=IF(A2=VLOOKUP(SHEET1!A$2,SHEET2!C$2:C$48,1,FALSE),"YES","NO")

Thanks!

 

[L. Howard]

Hi Blakerid,

Does this do it?

=IF(ISNA(VLOOKUP(Sheet1!A$2,Sheet2!C$2:C$48,1,FALSE)),"No","Yes")

Regards,
Howard

 

[Blakerid]

That does it! Thanks Howard!!

 

[Blakerid]

Would there be a way to Pull the original Vlookup data and then return a "No" if the data was not in the table?

 

[L. Howard]

Hmmm, like this?

=IF(ISNA(VLOOKUP(Sheet1!A$2,Sheet2!C$2:C$48,1,FALSE)),"No"&" "&A2,"Yes")

Howard

 

[Blakerid]

Material	Future Req	Prev. Comments
XXX	Yes	In blocked stock
YYY	No	New
ZZZ	No	New

<tbody>
</tbody>

Howard,

Here is the spreadsheet I am working with.
I used the first formula in the Future Req. The Yes and No work for that one.

Now I am trying to pull comments from an older spreadsheet in Prev Comments.
I would like to return the old comments from another table and if the part is not in the other table I am pulling from have it return a text field like "Not in Table" or "New".

Your Formula just returns the part number.

Hope this makes sense.


Thanks,

Blake

 

[Blakerid]

Howard,

I realized I was making this more complicated than it needed to be.
All I needed to do for the second formula was us an

=IFERROR(VLOOKUP),"NEW")

 

[L. Howard]

Okay, glad you got it working.

Regards,
Howard