![]() |
#1
|
|||
|
|||
![]()
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 Last edited by paulzy95; 08-09-2016 at 02:02 AM. |
|
![]() |
||||
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 |
![]() |
jackzha | Excel | 5 | 12-03-2014 12:43 PM |
Moving a Index/Match function | FraserKitchell | Excel | 2 | 01-19-2010 09:38 AM |