That is, If the word "Saxon" doesn't appear in column A, then use standard stock list and reference stock. If Saxon DOES appear in that column, reference the other lookup table.
That was easy enough.
The hard part, because my feeble dog-brain can't handle it: SOME of the packages I'm referencing come in a 25-pack. Which has its own independent stock reference. So, what I'm in the middle of, is something like "if A2<>Saxon and F2<>""Then Vlookup from F2." However, the double-if/lookup commas are giving me a pleasantly entertaining amount of grief.
"No no, don't tell me, I'm keen to guess."
--Cheese Shop Sketch