Before Excel2007, no function could accept more than 30 arguments. But many functions (still) accept only a limited number of
arguments. VLOOKUP accepts a maximum of 4 arguments:

1. the lookup value
2. the table array
3. the column number
4. (optional) the range lookup

What would you like to do?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"chrisbmo2000" wrote in message
...
| is there a limit to how many arguments you can use in a formula? to be
| specific the vlookup formula.