Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 12-04-2014, 08:56 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Issue with Index and Match logic Windows 7 64bit Issue with Index and Match logic Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

The second argument of match needs a range. This does not work with an IF statement. Please post a sample sheet with what you have and the expected results
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-04-2014, 09:02 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

Quote:
Originally Posted by Pecoflyer View Post
The second argument of match needs a range. This does not work with an IF statement. Please post a sample sheet with what you have and the expected results
Thank you. Attached is a sample of the spreadsheet, with the formula.
Attached Files
File Type: xlsx Country Rate Match Index.xlsx (10.5 KB, 12 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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 03:01 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