| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning multiple indices for a lookup | Excel Worksheet Functions | |||
| Returning Numeric Results across a Single Row in Consecutive Cells | Excel Worksheet Functions | |||
| Lookup Returning Multiple Results | Excel Discussion (Misc queries) | |||
| Returning multiple corresponding values using lookup in a list | Excel Discussion (Misc queries) | |||
| Returning multiple instances of the same lookup value | Excel Worksheet Functions | |||
Hybrid Mode
