Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-04-2014, 08:12 AM
vegasbound365 vegasbound365 is offline Issue with Index and Match logic Windows 7 64bit Issue with Index and Match logic Office 2010 64bit
Novice
Issue with Index and Match logic
 
Join Date: Dec 2014
Posts: 2
vegasbound365 is on a distinguished road
Default Issue with Index and Match logic

Greetings!
I am having issues with an index/match formula and I am hoping to receive some guidance on how to fix it.

I need to look up a value, say in cell F7 that goes to a table of data (table range is I7:AO64), MATCHES the value in cell F7, and returns the name of a country associated with the value in F7 - the names of the countries are listed in the range I4:AO4.

The formula I have right now, that is not working is:
=INDEX($I$4:$AO$4,MATCH(F7,IF($I$7:$AO$64=F7,$I$4: $AO$4),0),7)

Can anyone please help me correct this formula?

Thank you!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with Index and Match logic Index Match function jackzha Excel 5 12-03-2014 12:43 PM
Index, match in Pivottable and Pivotchart Newbies Excel 0 11-15-2014 12:58 AM
Help with multiple match and index formula ryanwood Excel 1 09-12-2012 07:53 AM
Match Index with sumproduct/vlookup angie.chang Excel 1 06-18-2012 08:47 AM
Moving a Index/Match function FraserKitchell Excel 2 01-19-2010 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 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