Quote:
Originally Posted by Pecoflyer
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!