Shorten this Excel Fomula?

[slaughteredlamb]

This is my current formula I'm using in an Excel spreadsheet that we use as our staff rota:

=IF(Checking!E13<3,"",CONCATENATE(VLOOKUP(Checking!E13,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E14,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E15,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E16,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E17,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E18,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E19,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E20,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E21,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E22,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E23,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E24,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E25,Staff!A20:C33,2,FALSE)))

However I now need to add three new members of staff which means amending this code to:

=IF(Checking!E13<3,"",CONCATENATE(VLOOKUP(Checking!E13,Staff!A20:B33,2,FALSE)," ",VLOOKUP(Checking!E14,Staff!A20:B33,2,FALSE)," ",VLOOKUP(Checking!E15,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E16,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E17,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E18,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E19,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E20,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E21,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E22,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E23,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E24,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E25,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E26,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E27,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E28,Staff!A20:C33,2,FALSE)))

However when I do this I get a message saying that I'm using too many arguments for this function.

Is there a way of perform the same function but in a shorter way?

[Whatever]

IIRC it's 7 arguments in an IF/ELSE statement but I'm afraid I wouldn't know how to shorten it sorry.

[JasonD]

There are only 3 arguments to the IF. I'd guess VLOOKUP(...) & " " & VLOOKUP... Instead of CONCATENATE().

[Whatever]

This is my current formula I'm using in an Excel spreadsheet that we use as our staff rota:

=IF(Checking!E13<3,"",CONCATENATE(VLOOKUP(Checking!E13,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E14,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E15,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E16,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E17,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E18,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E19,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E20,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E21,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E22,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E23,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E24,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E25,Staff!A20:C33,2,FALSE)))

However I now need to add three new members of staff which means amending this code to:

=IF(Checking!E13<3,"",CONCATENATE(VLOOKUP(Checking!E13,Staff!A20:B33,2,FALSE)," ",VLOOKUP(Checking!E14,Staff!A20:B33,2,FALSE)," ",VLOOKUP(Checking!E15,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E16,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E17,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E18,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E19,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E20,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E21,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E22,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E23,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E24,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E25,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E26,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E27,Staff!A20:C33,2,FALSE)," ",VLOOKUP(Checking!E28,Staff!A20:C33,2,FALSE)))

However when I do this I get a message saying that I'm using too many arguments for this function.

Is there a way of perform the same function but in a shorter way?

Just a thought and not tried it but would the following not work?

=IF(Checking!E13:E28,Staff!A20:B33,2,FALSE)