returning multiple cells for a single lookup
 

I need to match a part number and have it return the part number, the
quantity on hand, the value on hand, etc from a spreadsheet.

How do I match the part number and return multiple cells of information?

returning multiple cells for a single lookup
 

Depends how your data is set out.
Try looking up VLOOKUP in Excel help for pointers.
--
Traa Dy Liooar

Jock


"esloan" wrote:

I need to match a part number and have it return the part number, the
quantity on hand, the value on hand, etc from a spreadsheet.

How do I match the part number and return multiple cells of information?

returning multiple cells for a single lookup
 

Hi,

It is a VLOOKUP issue give me an idea of your data then i can make the
formula.

Thanks,
--
Farhad Hodjat


"esloan" wrote:

I need to match a part number and have it return the part number, the
quantity on hand, the value on hand, etc from a spreadsheet.

How do I match the part number and return multiple cells of information?