Hello,
I have a long list of alphanumeric serial numbers and I know what model they are if they fall within specific ranges - see attached.
Each range is defined by an Alpha Numeric serial range. all the lookup functions I have seen work on numeric ranges but I can't get those to work here..?
Trying to use something like vlookup, index, match or other combination to label my list from the chart of model ranges.
Any assistance would be much appreciated.
Bookmarks