Spotty Logic (spottylogic) wrote,
Spotty Logic

Excel Argh--

I've blown the last 30 minutes of my workday on this, which was very satisfying--I'm building a spreadsheet that uses two different "quantity in stock" lists to reference, well, the quantity of an item in stock, based on which company creates it. So, column 3:
=IF(A12<>"SAXON",VLOOKUP(TRIM(B12),Stock!A:C,3,FALSE),VLOOKUP(TRIM(B12),'Saxon Stock'!A:C,3,FALSE))
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
  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened