MATCH can search for a single value only. One solution is to create a formula that tests each possibility separately, but the way that works is to first search for one value, then if it's not found search for the other. From your description you may want to find the first match to either value, so this may not work for you. It gets long, and I haven't tested this to see if it works, only that it is a legal formula:
The other solution would be to write some VBA to either create a UDF, or just provide the value into the cell. However, the Range.Find method will search only for one value as well so the search would have to be coded manually as a For Each loop for every cell in the range.
I would personally code a general-purpose UDF called something like MULTIMATCH that takes multiple parameters for the value to match.
[/COLOR][/SIZE][/FONT]
Bookmarks