?

Log in

No account? Create an account

Previous Entry | Next Entry

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

Comments

( 2 comments — Leave a comment )
khime
Sep. 16th, 2005 04:12 pm (UTC)
Okay, I won't tell you. :-)
spottylogic
Sep. 16th, 2005 04:23 pm (UTC)
Thanks :) I *can* look this up in the manual(s), but it's more fun to try to puzzle it out...
( 2 comments — Leave a comment )

Latest Month

August 2011
S M T W T F S
 123456
78910111213
14151617181920
21222324252627
28293031   

Page Summary

Powered by LiveJournal.com
Designed by Taylor Savvy