Chrisbmo

If you had the following in columns A,B and C then a concatenate text formula;
=A1&" "&B1&"/"&C1
would give the result shown in column D. And if you want to lookup the price
then just substitute a lookup formula instead of the cell reference eg
=A1&" "&VLOOKUP(A1,A1:B3,2,FALSE)&"/"&C1


Apples $2.65 kg Apples $2.65/kg
Oranges $1.50 kg Oranges $1.50/kg
Pears $1.00 kg Pears $1.00/kg


"T. Valko" wrote:

The VLOOKUP function can accept a maximum of 4 arguments:

1. lookup_value
2. table_array
3. column_index_number
4. [optional] range_lookup

However, to complicate matters, each argument can be calculated using other
functions that have their own set of arguments.

So, I think you need to be a bit more specific as to what you're wanting to
do!

--
Biff
Microsoft Excel MVP


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