Match takes 3 arguments not 4. Delete your final zeros as a guess.

=if(c2 OFFSET(Sheet2!$I$10,MATCH(I2,Sheet2!G$11:G$27,FALS E),0),
OFFSET(Sheet2!$j$10,MATCH(I2,Sheet2!G$11:G$27,FALS E),0),
OFFSET(Sheet2!$K$10,MATCH(I2,Sheet2!G$11:G$27,FALS E),0))

--
HTH...

Jim Thomlinson


"Xhawk57" wrote:

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,FALS E,0),0),
OFFSET(Sheet2!$j$10,MATCH(I2,Sheet2!G$11:G$27,FALS E,0),0),
OFFSET(Sheet2!$K$10,MATCH(I2,Sheet2!G$11:G$27,FALS E,0),0))

Also tried:
=if(c2 OFFSET(Sheet2!$I$10,MATCH(I2,Sheet2!G$11:G$27,FALS E,0)),
OFFSET(Sheet2!$j$10,MATCH(I2,Sheet2!G$11:G$27,FALS E,0)),
OFFSET(Sheet2!$K$10,MATCH(I2,Sheet2!G$11:G$27,FALS E,0)))