Results 1 to 11 of 11

if vlookup yields no results then try another vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    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.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using VLookup but results show formula instead of results...
    By excel me in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-28-2013, 09:40 PM
  2. VLookup that Results with False or Blank Results
    By mycon73 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-12-2013, 07:16 PM
  3. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM
  4. Custom Autofilter yields no results
    By rjejyork in forum Excel General
    Replies: 4
    Last Post: 07-20-2006, 04:15 PM
  5. 6th order polynomial equ yields unexpected results
    By Sanjay Kumar Limbikai in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-26-2005, 08:05 PM

Tags for this Thread

Bookmarks

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