ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IF, OFFSET,MATCH Please Help (https://www.excelbanter.com/excel-discussion-misc-queries/190350-if-offset-match-please-help.html)

Xhawk57
IF, OFFSET,MATCH Please Help
 
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)))

Jim Thomlinson
IF, OFFSET,MATCH Please Help
 
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)))


All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com