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?
Jock - 22 Aug 2007 15:36 GMT
Depends how your data is set out.
Try looking up VLOOKUP in Excel help for pointers.

Signature
Traa Dy Liooar
Jock
> 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?
Farhad - 22 Aug 2007 18:52 GMT
Hi,
It is a VLOOKUP issue give me an idea of your data then i can make the
formula.
Thanks,

Signature
Farhad Hodjat
> 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?