I have a problem where I'm looking for a general approach rather than
specific answers...

...I have a string such as P1234 and a series of rules that assign cost
codes to this string. Such as:
P***N Cost Code 1
P1*** Cost Code 2
P2*** Cost Code 3
C***4 Cost Code 4, etc

In the above example the first rule would trump the subsequent rules.

I would love VLOOKUP to have a wildcard function but I don't think
there is one. My current solution has a bunch of nested IFs and
Lookups but its non-flexible and has to be rebuilt every time cost code
structures change.

Any thoughts on an approach to this?

Thanks in Advance!


--
Jonathan May
------------------------------------------------------------------------
Jonathan May's Profile: http://www.excelforum.com/member.php...o&userid=10924
View this thread: http://www.excelforum.com/showthread...hreadid=502893