Hi
thanks for the reply. I tried including the entire table,
but the error now is N/A for all the entries..
the problem is..
i have a small list of products and I want to know their
sales price(the last time they were sold). I have a big
excel sheet with historic sales data in seperate
worksheet. Now, I want to use vlookup to find the sales
price of the list of products. the sales proce is in
worksheet'historic_sales' in coloumn 'P'. The small list
of products whose prices i need are in worksheet 'list'.

Hope i made my problem clear.
thanks a lot for a help
cheers,
samantha