+ Reply to Thread
Results 1 to 2 of 2

Run VLOOKUP only for data coming from a particular source

  1. #1
    Registered User
    Join Date
    10-17-2017
    Location
    chciago
    MS-Off Ver
    2013
    Posts
    29

    Run VLOOKUP only for data coming from a particular source

    I am working on a master sheet that contains data from 2 separate sheets (Say SheetA and SheetB). I need to run VLOOKUP functions on the master sheet in order to pull some information in from a fourth sheet.

    Here is essentially the question I am asking: : IF my data came from SheetA, THEN run this VLOOKUP, IF my data came from SheetB THEN run this VLOOKUP.

    My problem is that depending on where my data came from (either SheetA or SheetB) I will run different VLOOKUPs against it. For instance In column G I only want to run a VLOOKUP if the data came from SheetA, but in column H I want to run a different VLOOKUP if the data came from SheetB. Right now when I drag my VLOOKUP over data coming from a source not referenced in the VLOOKUP I get #REF errors and Instead of those #REF errors I would like to just see the cells as blank.

    Essentially I would just like to enter these formulas once at the top of my master sheet so they can be dragged down the length of the sheet and properly render regardless of where the data came from.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Run VLOOKUP only for data coming from a particular source

    Try something like this:

    =IFERROR(vlookup_one,vlookup_two)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOKUP coming back as #N/A (some of the time)
    By Clanty in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 05-25-2016, 03:13 PM
  2. [SOLVED] Formatting data coming from external source into excel
    By lwilt in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-27-2016, 12:22 PM
  3. Vlookup not selecting source data
    By Me & I in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2013, 04:34 AM
  4. VLOOKUP Formula coming back with NA#
    By monza2 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-18-2012, 01:38 AM
  5. Vlookup not selecting source data
    By tryer in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-15-2010, 01:30 PM
  6. Values not coming in few cell but coming in rest all cells
    By rashmib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 11:19 AM
  7. Vlookup function not working if alphabet coming after '-' in the search term
    By ElerOcean in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2007, 11:40 AM

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