#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thank you. Attached is a sample of the spreadsheet, with the formula.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |