You've entered too many arguments for this function

You have 5 arguments in your VLOOKUP() function, but VLOOKUP() only takes 4 arguments. Which value/reference is intended for the lookup value: A4 or B3?

Or, looking more closely, perhaps your hope was to look for both values? VLOOKUP() can search for one value, but not two. If you can add a helper column (in the leftmost column) that combines your desired search terms into a single search term, then you can combine them and search for the combined text string. If that is the case, then AU is currently blank, so maybe add a concatenate function to AU =CONCATENATE(AX8,AW8) in AU8 and copy/fill down. Then change your VLOOKUP function to include AU as the search column VLOOKUP(CONCATENATE($A4,B$3),INDIRECT("'"&B&2&"'!$AU$7:$BC$132"),5,FALSE)

Does that help?

Try This in B4

HTML Code: 

Drag it across and down. This will pick up all hours for the combination you're looking for.

VLOOKUP will pick up just first found value. If you want to add all hours that match your search criteria then you may need SUMPODUCT of maybe a SUMIFS formula.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.