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,101
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

Thread Tools
Display Modes


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 09:47 AM.


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