Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2014, 12:07 PM
jackzha jackzha is offline Index Match function Windows 7 64bit Index Match function Office 2013
Novice
Index Match function
 
Join Date: Dec 2014
Posts: 3
jackzha is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
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)
( the character before the question mark is a "tilde" or "swung dash")
Thanks for replying! This works fine for one material, but the problem is, we have a ton of different materials, probably hundreds, with this kind of coding convention, and they are all in the same array and it would be very time consuming if not impossible to enter the formula you mentioned for each and everyone of them. Is there a work-around formula that can be applied to the whole array without being specific abo
ut what I need to match?

Thanks!
Reply With Quote
Reply

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

Other Forums: Access Forums

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