Hello Everyone,
I've been trying to derive a formula for an excel template that I created. What I'm trying to do
is Look at the quantity column in my spreadsheet and if it falls between a particular amount, then I what the
computer to go to another tab and lookup the informations using the part number from the previous tab. Could
someone please help!!!!!! I'm pulling my hair out.
Formula: IF(AND(F4>=0,2000>=F4),VLOOKUP(B4,Baseline!A2:I65,5,FALSE)),IF(AND(F4>2000,5000>=F4),
VLOOKUP(B4,Baseline!A2:I65,6,FALSE)),IF(AND(F4>5000,10000>=F4),VLOOKUP(B4,Baseline!A2:I65,7,FALSE)),
IF(AND(F4>10000,20000>=F4),VLOOKUP(B4,Baseline!A2:I65,8,FALSE)),IF(AND(F4>20000,40000>=F4,
VLOOKUP(B4,Baseline!A2:I65,8,FALSE)),IF(F4>40000,VLOOKUP(B4,Baseline!A2:I65,8,FALSE)))
Thanks,
Heather