Are you looking for the product in a specific department or do you want to
return information on the product from each of that products rows.

A formula can not move down, so you have to preenter formulas in all the
cells where you want output and

send me a small workbook with some sample data and what you want returned
for an example product and I will send you an example of how to get it.

--
Regards,
Tom Ogilvy


"donkey brain" wrote:

if i use vlookup to search for a product name and there are more than one
product with the same name, but they are different departments off which this
information is in a diferent column.
how can i then move down to a diferent cell once i have found the product.
=VLOOKUP("SPRG280",Data!A:J,3,FALSE)
2003 excel