![]() |
|
#1
|
|||
|
|||
|
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! |
|
|
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 |