Thread: Idex(match
View Single Post
 
Old 05-22-2017, 03:57 PM
abdbfan abdbfan is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: May 2017
Posts: 1
abdbfan is on a distinguished road
Default 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
Reply With Quote