Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-22-2017, 03:57 PM
abdbfan abdbfan is offline Idex(match Windows 10 Idex(match Office 2010 64bit
Novice
Idex(match
 
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
  #2  
Old 05-22-2017, 09:07 PM
xor xor is offline Idex(match Windows 10 Idex(match Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Please upload your Excel file.
Reply With Quote
Reply

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
Idex(match 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 AM.


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