arguments in a formula
I would like to display product name and price with one vlookup formula if
possible but the info is in 2 diffrent columns
"Niek Otten" wrote:
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.
|