| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type in Part number which pulls info from another wksheet
I am trying to set up a worksheet for parts to which when I enter a part
number it will pull information (description & price) from another worksheet. Can someone advise me how to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Type in Part number which pulls info from another wksheet
Look at VLOOKUP in help.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "JB" wrote in message ... I am trying to set up a worksheet for parts to which when I enter a part number it will pull information (description & price) from another worksheet. Can someone advise me how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| How do I type in a number that begins with zero? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
