Hi,

I know there are probably a 100 answer's already posted about this but I
can't get one to match. I have a Vlookup formula that i can get to work
looking across 2 worksheets but when i add the 3rd it says "too many
arguments". my existing formula is:

=IF(ISERROR(VLOOKUP($A97,'sheet1'!$A$3:$AR$99,11,F ALSE)),VLOOKUP($A97,'sheet2'!$A$4:$AR$98,11,FALSE) ,VLOOKUP($A97,'sheet1'!$A$3:$AR$99,11,FALSE))

I want to add sheet 3 in there but it returns the error. I'm using
consistent formatting $'s & the worksheets are uniformly set out.

Any help would be appreciated, especially understanding the brackets/equation.

Thanks