Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-08-2016, 10:31 PM
paulzy95 paulzy95 is offline Excel - Index and Match Function ,First  Second and Third Match Windows 7 32bit Excel - Index and Match Function ,First  Second and Third Match Office 2016
Novice
Excel - Index and Match Function ,First  Second and Third Match
 
Join Date: Aug 2016
Posts: 9
paulzy95 is on a distinguished road
Post Excel - Index and Match Function ,First Second and Third Match

Hey Guys,
I've been stuck on this problem, It has real world application. As a simplification:
I have a fixed table with:


a | Gold
b | Silver
b | Aluminium
c | Tin
c | Copper
c | Hydrogen
d | Helium
e | Lithium

Now I have a different table, where I need an excel function to input and fill out this table based on the criteria of the table above.



[Column] [Column] [Column]
[First Match] [Second Match] [Third Match]
a
b
c
d
e

I need a function that would populate the table like so:

[Column] [Column] [Column]
[First Match] [Second Match] [Third Match]
a Gold N/A N/A
b Silver Aluminium N/A
c Tin Copper Hydrogen
d Helium N/A N/A
e Lithium N/A N/A

So far I can get the first column to work, but I can't get a function that will produce a second and third match. So far the most progress I have made has been for the first column which works with a =index match function. I have attached an excel document with my progress of this.

Any help will be most appreciated! Thanks for reading!

Cheers,

Best Regards
Attached Files
File Type: xlsx Index Match Problem.xlsx (8.8 KB, 17 views)

Last edited by paulzy95; 08-09-2016 at 02:02 AM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Index Match Function across different worksheets shay_mt Excel 2 04-27-2015 06:04 AM
Index match vba grexcelman Excel 0 03-05-2015 10:55 PM
UDF multiple IFs INDEX-MATCH grexcelman Excel Programming 0 02-22-2015 04:20 PM
Excel - Index and Match Function ,First  Second and Third Match Index Match function jackzha Excel 5 12-03-2014 12:43 PM
Moving a Index/Match function FraserKitchell Excel 2 01-19-2010 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft