Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-02-2016, 02:34 AM
chappers chappers is offline Index Match - Urgent Help Mac OS X Index Match - Urgent Help Office 2007
Novice
Index Match - Urgent Help
 
Join Date: Nov 2016
Posts: 2
chappers is on a distinguished road
Default Index Match - Urgent Help

I need urgent help with index match - or at least thats what formula i think is needed.



Please see enclosed file across two sheets.

I need to be able to match two values i manually input on sheet1 ('campaign' and 'conversion action name') with values on sheet2 and populate the corresponding values in the 'conversions' column on sheet2 into the 'conversions' cell in sheet1.

Hope this makes sense.
Attached Files
File Type: xlsx index-match-example.xlsx (27.6 KB, 13 views)
Reply With Quote
  #2  
Old 11-02-2016, 03:15 AM
xor xor is offline Index Match - Urgent Help Windows 10 Index Match - Urgent Help 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

See the attached.
Attached Files
File Type: xlsx index-match-example_2.xlsx (10.8 KB, 9 views)
Reply With Quote
  #3  
Old 11-02-2016, 03:17 AM
chappers chappers is offline Index Match - Urgent Help Mac OS X Index Match - Urgent Help Office 2007
Novice
Index Match - Urgent Help
 
Join Date: Nov 2016
Posts: 2
chappers is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
See the attached.
You, my friend, are genius! Thank you so so much!
Reply With Quote
Reply

Tags
excel 2011, 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 and Match functions aman.chauhan Excel 1 06-18-2016 02:09 AM
Translate INDEX(MATCH) into VBA grexcelman Excel Programming 1 03-08-2015 05:06 PM
Index match vba grexcelman Excel 0 03-05-2015 10:55 PM
Index Match syntax grexcelman Excel Programming 0 03-05-2015 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 PM.


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