T
Tacklemom
I am trying to come up with a formula that incorporates muliply variables. I
know that formula for 2 variable that I have used is:
=if(a7=304,vlookup(a9,screens!$a$27:$h$37,3,false),vlookup(a9,screens!$a$27:$h$27,4,false))
I want the A9 to be constant as that is the cell that tells the formula the
column to look up. The second variable is material and I have 8 options and
eight columns set up is there a way that my senerior it has to equal ( eg
size 60 and material 304) and I tell it the cell to look up based on those
two numbers/data being met??
know that formula for 2 variable that I have used is:
=if(a7=304,vlookup(a9,screens!$a$27:$h$37,3,false),vlookup(a9,screens!$a$27:$h$27,4,false))
I want the A9 to be constant as that is the cell that tells the formula the
column to look up. The second variable is material and I have 8 options and
eight columns set up is there a way that my senerior it has to equal ( eg
size 60 and material 304) and I tell it the cell to look up based on those
two numbers/data being met??