+ Reply to Thread
Results 1 to 5 of 5

Index information from another sheet

  1. 05-09-2023, 06:53 PM #1
    alexxl
    alexxl is offline
    Forum Contributor alexxl's Avatar
    Join Date
    04-21-2015
    Location
    Romania
    MS-Off Ver
    2019/2010
    Posts
    308

    Index information from another sheet

    In col k desired results brought from sheet 2 matching col a data, col g service, and col j kpi id

    Index.xlsx


    Alex
    Reply With QuoteRegister To Reply
  2. 05-09-2023, 07:22 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,036

    Re: Index information from another sheet

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 05-09-2023, 08:25 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,036

    Re: Index information from another sheet

    Thanks for the rep.
    Reply With QuoteRegister To Reply
  4. 05-09-2023, 08:31 PM #4
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Index information from another sheet

    Hi alexxl,

    How about using the newer XLookup() formula? Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    XLookup Multiple Cells.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  5. 05-10-2023, 01:14 AM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,036

    Re: Index information from another sheet

    @MarvinP: the OP's profile says 2010.
    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] Need to use index match to pull information from a different sheet
    By anderem12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2020, 11:46 AM
  2. [SOLVED] VBA Code for auto updating information on a sheet with information from another sheet
    By Nitro2481 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2015, 08:46 AM
  3. 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
  4. [SOLVED] Enter information on one sheet based on the information in another sheet in the same wkbk
    By slindfors in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2015, 03:16 PM
  5. Macro to Pull information from one Excel Sheet based on information in another sheet
    By IwannabanExcelGod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 02:11 PM
  6. Index sheet indication of status of following sheet information.
    By John Brooks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2012, 11:49 AM
  7. Copying Information From Another Sheet Via Index
    By snapa in forum Excel General
    Replies: 1
    Last Post: 12-11-2009, 10:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1