One way
Assuming source table in Sheet1, cols A to C (extendable across)
Try something like this in another sheet:
=VLOOKUP(A1,Sheet1!A:Z,COUNTA(Sheet1!$1:$1),0)
where the col index would be determined by the number of filled cells in
row1, which number corresponds to the rightmost col number.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arup C" wrote:
Hi Everybody,
I am making a billing system which will pick product prices automatically
from a price list of products. My prices should change automatically
according to latest price. I have products like this
column A column B column C
Product price as 1.11.07 price as on 10.11.07
Milk 12.50 14.00
Chocolate 40.00 50.00
Ice cream 20.00 30.00
Soda 10.00 12.00

now I have created a dynamic named range called pricing which increases a
column with every new price.
Now my question is that is there any way that Vlookup function automatically
change the column index number to the last column of the range (pricing)? in
this case from 2(col b) to 3 (col c)