Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wildcard vlookup perhaps?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with wildcard | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Wildcard search functions within Vlookup | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |