WILD CARDs (?) In Pivot Tables or Better Method.

[srmorgan]

I have a problem with identifying some fields.
In column R I have a three-digit code (all numeric) but could be converted to text if that provides a better solution.
In column T I have to identify the code as follows:
Using "?" as a wild card.

11? "MAM"
32? "XRAY"
35? "CT"
61? "MRI"
67? "US"
all others "OTH"
Except for
483 "ECHO"
but 484, 485, 486 are "others"

Just not sure if this works better with a lookup or a pivot table and I am stumped about using wild cards.

All ideas are appreciated
Thank you
SRMORGAN

 

[Aladin Akyurek]

S2, copied down:

=IFERROR(LOOKUP(9.99999999999999E+307,
    FIND("|"&{11,32,35,61,67,483},"|"&R2),
   {"MAM","XRAY","CT","MRI","US","ECHO"}),"OTH")

 

[srmorgan]

Thank you, we'll give it a try today

SRM

 

[SpillerBD]

Not an answer, but "philosophically".... When a "numeric" value is a label and not really a value that could be added to another, I always treat as text. In the long run it always seems to happen that an alpha-prefix/suffix will get added and create all kinds of havoc elsewhere.