#1
|
|||
|
|||
Idex(match
Need help with the INDEX & MATCH Function using two sheets.
Below is Sheet1 and in column E is the result from my function and in column F is what I was expecting it to be: Since I'm using headers, my first function in Row 2 and it is: =INDEX(Sheet2!$A:$G,MATCH(A2,Sheet2!$A:$A,0),MATCH (D2,Sheet2!$C:$C,0)) A B C D E F Data 1 Data 2 Data 3 Data 4 Current outcome Should be 1#2#3 1 2 3 Blue Blue 1#3#3 1 3 3 Green Green 2#2#4 2 2 4 xyz Red 2#3#4 2 3 4 xyz Yellow 3#2#5 3 2 5 3 Orange 3#3#5 3 3 5 3 White Here is Sheet2: Data 1 Data 2 Data 3 Data 4 Data 5 Data 6 Data 7 1#2#3 Blue 3 xyz qrs 1 2 1#3#3 Green 3 xyz qrs 1 3 2#2#4 Red 4 xyz qrs 2 2 2#3#4 Yellow 4 xyz qrs 2 3 3#2#5 Orange 5 xyz qrs 3 2 3#3#5 White 5 xyz qrs 3 3v |
#2
|
|||
|
|||
Please upload your Excel file.
|
Tags |
index match |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
MATCH Function | namedujour | Excel | 1 | 07-20-2012 12:12 AM |
match formatting help | Lynnwork | Excel | 1 | 12-02-2011 08:39 AM |
Need another formula to match my last one | tinkertron | Excel | 2 | 04-29-2009 02:17 PM |