+ Reply to Thread
Results 1 to 3 of 3

Look up accross multiple columns

  1. #1
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    Look up accross multiple columns

    Hello,

    I have data with a description in one column and an ID in another.
    Is it possible to take the ID and the end letter of the description and look up the description?

    I enclose and example.
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,503

    Re: Look up accross multiple columns

    you can do it with this index/match, BUT this is an array formula so it needs to be activated using ctrl/shift/return so that {} appear on each end, YOU CANNOT add them to the formula. It will look like this when properly activated.
    {=INDEX($A$2:$A$11,(MATCH(I2&J2,$B$2:$B$11&RIGHT($A$2:$A$11,1),0)))}
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    Re: Look up accross multiple columns

    Thank you. Just what I was looking for.

+ 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. [SOLVED] formula to sum accross multiple columns?
    By Todd6262 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2019, 02:27 PM
  2. [SOLVED] Count Multiple Values accross Multiple Columns
    By Bendigus in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 08-24-2017, 01:31 PM
  3. Lookup Accross Multiple Columns
    By Jay_hl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2016, 12:11 AM
  4. [SOLVED] Index Match accross two sheets with two crieteria searching in multiple columns
    By EmmatheDancer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-09-2015, 11:56 AM
  5. SUM MAX accross columns
    By manywise in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 04-08-2011, 07:13 AM
  6. VBA Remove duplicate entries accross multiple columns??
    By siegreen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2010, 06:03 AM
  7. [SOLVED] SUMIF accross multiple columns
    By X in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2005, 01:06 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