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

  • Aww :)

    So for YEARS the University of Texas Pagan, Vampire Larp, and GLBT groups tended to cluster around a particular oak tree in the west mall. I think we…

  • cargrump

    Whoof. I've taken a few beatings over the last few days over this. My office is moving across town, which spells an end for my nice little commute…

  • Tonight's experiment--

    Okay, so it's Dogai's birthday tonight. Bauson said that D really liked "biscoff" cookies, which are buttery little things with a touch of spice, and…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened