X
Xhawk57
Can anyone tell me what I am doing wrong? I am getting a to few arguments
error message and I am going blind staring at it.
=if(c2> OFFSET(Sheet2!$I$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0),0),
OFFSET(Sheet2!$j$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0),0),
OFFSET(Sheet2!$K$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0),0))
Also tried:
=if(c2> OFFSET(Sheet2!$I$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0)),
OFFSET(Sheet2!$j$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0)),
OFFSET(Sheet2!$K$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0)))
error message and I am going blind staring at it.
=if(c2> OFFSET(Sheet2!$I$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0),0),
OFFSET(Sheet2!$j$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0),0),
OFFSET(Sheet2!$K$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0),0))
Also tried:
=if(c2> OFFSET(Sheet2!$I$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0)),
OFFSET(Sheet2!$j$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0)),
OFFSET(Sheet2!$K$10,MATCH(I2,Sheet2!G$11:G$27,FALSE,0)))