+ Reply to Thread
Results 1 to 5 of 5

Lookup a value from 2 similar groups of data and return the value using the correct group

  1. #1
    Registered User
    Join Date
    04-11-2010
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    40

    Lookup a value from 2 similar groups of data and return the value using the correct group

    Hi, please refer to the attached excel.

    Is there anyway to return the value from the correct column "Bravo" if I key in the type of either "RCS302" or "RCS502" and a value from "Alpha" column

    Thanks for your help
    Attached Files Attached Files
    Last edited by xWiZardx; 08-27-2015 at 11:22 AM.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Lookup a value from 2 similar groups of data and return the value using the correct gr

    Try this:

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Lookup a value from 2 similar groups of data and return the value using the correct gr

    =index($a$3:$e$63,match(h4,index($a$3:$e$63,0,match(h3,$a$1:$e$1,0)),0),match(h3,$a$1:$e$1,0)+1)
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    24,289

    Re: Lookup a value from 2 similar groups of data and return the value using the correct gr

    Try ...

    =IFERROR(IF($H$3=$A$1,VLOOKUP($H$4,$A$3:$B$63,2,1),VLOOKUP($H$4,$D$3:$E$63,2,1)),"")

    assumes only your 2 tables and will find closest match if there is not an exact match.

  5. #5
    Registered User
    Join Date
    04-11-2010
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    40

    Re: Lookup a value from 2 similar groups of data and return the value using the correct gr

    Thank you all for the help!

+ 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] Lookup does not return correct value
    By AnnaBX in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-29-2014, 10:48 AM
  2. Replies: 11
    Last Post: 03-13-2014, 08:23 PM
  3. group data into groups of 10
    By jmccarthy0901 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2013, 05:12 PM
  4. lookup 2 columns that are data validated wont return correct info
    By imatthews2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 02:31 PM
  5. Not Able to Get LOOKUP to Return Correct Data
    By ngoedken in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2009, 08:19 PM
  6. Selecting Groups of Similar Data
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2009, 09:28 AM
  7. [SOLVED] How do I group multiple data entries in sub-groups
    By wendyrose1034 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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