I'm having trouble setting up the validation list
I would like the name of the shop to appear in the list,
but the value resulting is the MA number letter combos to be used in the sumproduct,

I have this in a cell:
[VBA]"1Z","1X","3L"[/VBA]
and use a data Val to pick this combo
The dataval is named officeChoice
This is one the chart source:
[VBA]=SUMPRODUCT(--(item27=scan_item),--(QCDate>=chStart),--(QCDate<=chEnd),--(ISNUMBER(MATCH(MA,officeChoice,0))))[/VBA]
Also I saw the ISNUMBER, does this work on letters too,
some of the MA's have just number where others are number and letter (1X)?