HMATCH star matching
In message of Tue, 28 Aug 2007
09:00:30 in microsoft.public.excel.worksheet.functions, Peo Sjoblom
writes
Try either this
=VLOOKUP(Grade,{"A*",58;"A",52;"B",46;"C",40;"D", 34;"E",28;"F",22;"G",16
;"U",0},2,0)
or this
=HLOOKUP(Grade,{"A*","A","B","C","D","E","F","G", "U";58,52,46,40,34,28,2
2,16,0},2,0)
Thank you! Both work. I had started with LOOKUP which needs sorted input
and "A" < "A*".
--
Walter Briscoe
|