|
|
#2
12-03-2014, 10:49 AM
|
||||
|
||||
Hi and welcome
I think that is because the question mark is used as wildcard in excel. Instead of looking for "abc?" try Code:
=match("abc"&"~?",your_range,0)
__________________
Using O365 v2503 - 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 
|
| Tags |
| index/match, text string |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Index, match in Pivottable and Pivotchart | Newbies | Excel | 0 | 11-15-2014 12:58 AM |
| Complex Formula using INDEX and Match needed | OTPM | Excel | 5 | 05-23-2013 01:22 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 |
Index Match function
Windows 7 64bit 
Office 2010 64bit
Threaded Mode