+ Reply to Thread
Results 1 to 6 of 6

Vlookup/Index/Match on multiple sheets data

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Vlookup/Index/Match on multiple sheets data

    I tried searching before I posted this, but I cant find the answer. I need to look up data from multiple sheets.

    for example,

    Sheet1
    Capture.PNG

    Sheet2
    Capture2.PNG

    Sheet3
    Capture3.PNG

    please help with the formula if i need to look up data for Sheet 3 B2 and B3
    Last edited by yabi0823; 12-29-2014 at 09:53 PM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,748

    Re: Vlookup/Index/Match on multiple sheets data

    =iferror(vlookup(A1,sheet1!A1:B2,2,false),vlookup(A1,sheet2!A1:B2,2,false))
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,263

    Re: Vlookup/Index/Match on multiple sheets data

    On Sheet3 cell B1 and copied down:

    =IFERROR(VLOOKUP($B1,Sheet1!$B$1:$C$2,2,FALSE),IFERROR(VLOOKUP($B1,Sheet2!$B$1:$C$2,2,FALSE),""))

  4. #4
    Registered User
    Join Date
    12-29-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Vlookup/Index/Match on multiple sheets data

    thanks! you save my life!!

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Vlookup/Index/Match on multiple sheets data

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  6. #6
    Registered User
    Join Date
    12-29-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Vlookup/Index/Match on multiple sheets data

    Quote Originally Posted by humdingaling View Post
    thanks! i do have more than 2 sheets.

+ 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 (or index/match) with multiple criteria over multiple sheets
    By Groovicles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2013, 01:56 PM
  2. Looking up data from two sheets with vlookup or index and match
    By joeycrak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2013, 04:56 PM
  3. Replies: 3
    Last Post: 08-07-2011, 06:52 AM
  4. Index / Match / Vlookup Loop across 3 sheets
    By NewExcelUser in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2009, 03:27 AM
  5. Need data cross-referenced in multiple tables: VLOOKUP vs. Match vs. Index
    By James McMurray in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2008, 02:53 PM

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