How to add more ranges to my formula

[Janbi]

When I try to add more ranges to my formula I get the error 'too many arguments for this function' could somebody tell me how to achieve the following;

=IFERROR(INDEX(Monday!$G$47:$I$47,MATCH(MIN(IF(Monday!$G$48:$I$68=INDEX(Monday!$B$3:$K$3,MATCH(Sheet1!A2,Monday!$B$4:$K$4,0)),COLUMN(Monday!$G$48:$I$68)-1)),COLUMN(Monday!$G$48:$I$68)-1,0)),"Holiday")

I basically need to change the bits in bold so that they include; B3:K3, A10:K10, B17:H17, B24:H24 and B4:K4, A11:K11, B18:H18, B25:H25. How do I achieve this?

Thanks in advanced.

[Solomon14all]

Either u should be genius or gone mad. Because i went mad seeing this formula.

Raj.

[Janbi]

I almost went mad myself, but I've had a lot of help from people here.

Is there anyone who knows how to add more ranges to the areas I've pointed out? That's all I need to do now!

[Janbi]

I get an error saying too many arguments used in function, can you copy me the formula so I can try it please?

[mmmarks]

not sure but try dis one,

Please Login or Register  to view this content.

[Janbi]

I don't see any difference with what you posted to my formula?

[FDibbins]

do you wqant ALL of "B3:K3, A10:K10, B17:H17, B24:H24 and B4:K4, A11:K11, B18:H18, B25:H25" to be included in your formula?

[Janbi]

do you wqant ALL of "B3:K3, A10:K10, B17:H17, B24:H24 and B4:K4, A11:K11, B18:H18, B25:H25" to be included in your formula?

I'd basically like to include A10:K10, B17:H17 and B24:H24 into

Please Login or Register  to view this content.

and A11:K11, B18:H18 and B25:H25 into

Please Login or Register  to view this content.

, hope this helps

[FDibbins]

do you have a sample file for me to play with?

[Janbi]

I'll make a sample sheet now.

[Janbi]

Here's a sample sheet explaining what it is I'd like to do. The formula is in Sheet1, cell B1.

[Janbi]

Anyone? Is it impossible?

[ChemistB]

So, there will be only 1 match for Sheet1!A1 and it could be in row 4, 11, 18 or 25, correct?
and you want the value above it to be returned?
Hmmm, tough one, I'll think on it.

[Janbi]

That is correct Thank you I appreciate it!

[ChemistB]

Okay, I used this formula

Please Login or Register  to view this content.

where M12 is the cell where you put the name you want to look up. Ranges are from your example. I have attached a spreadsheet. Would this work for you?

I make the assumption that names will only appear in the rows you mentioned so searching the other rows wouldn't cause an issue.

[Janbi]

That doesn't work for me, I need it to take the vehicle classification from G47-I68 rather than the vehicle itself.

[ChemistB]

The formula searches for a specific value, i.e. in your example, Bob and returns the value in the cell above that (i.e P20 PFS) What is it that you want to return and where is it relative to the term you are searching for?