r1c1, this is great solution - so simple! J
I do prefer this one as others who will be using the spreadsheet might run into trouble with other solutions based on array formulas.
Thanks!
Peter
I have a challenge with VLOOKUP: I get a lot of data out of an ERP system which in one of the fields has one or more "*" as the first characters (See sample B4:C13).
In order to classify the many records I have a table for lookup ( F4:F15) and I do VLOOKUP (Col A) to find the right "Monthly...