+ Reply to Thread
Results 1 to 3 of 3

Need to use index match to pull information from a different sheet

  1. 10-13-2020, 11:27 AM #1
    anderem12
    anderem12 is offline
    Registered User
    Join Date
    12-11-2019
    Location
    MN
    MS-Off Ver
    2016
    Posts
    55

    Need to use index match to pull information from a different sheet

    I am trying to match one criteria from sheet 1 to sheet 2 to try and pull the information from a cell.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-13-2020, 11:45 AM #2
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,328

    Re: Need to use index match to pull information from a different sheet

    In E2, copied down:

    =IFERROR(VLOOKUP(Sheet1!A2,Sheet2!A:B,2,FALSE),"")
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 10-13-2020, 11:46 AM #3
    mikeava
    mikeava is offline
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Need to use index match to pull information from a different sheet

    Here you go. I used VLOOKUP though.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index match to pull through column information fom one tab to another help
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-02-2019, 03:35 AM
  2. INDEX & MATCH - Trying to pull information from two worksheets based on matching dates
    By Wrayden in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-02-2018, 10:25 PM
  3. Index Match Function To Pull Multiple Consistent Rows of Information Rather Than 1st One
    By adamdeeakaaj in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-01-2016, 12:18 PM
  4. trying use index match to pull information from database to individual sheet
    By garvey1973 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-20-2015, 07:33 PM
  5. Need Help: Pull Data from another Sheet using INDEX, MATCH functions etc
    By eummagic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2013, 01:45 AM
  6. [SOLVED] Excel 2007 : How do I use Index/Match formula to pull certain information?
    By srgtennis in forum Excel General
    Replies: 8
    Last Post: 07-09-2012, 02:38 PM
  7. Pull Information off of database with INDEX, MATCH into a form.
    By shedir911 in forum Excel General
    Replies: 8
    Last Post: 03-22-2012, 03:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1