how do i vlookup and move down a cell as well.

[Guest]

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

 

[Guest]

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.

 

[Guest]

(e-mail address removed)