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 3
Bookmarks