| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find and returning data.
Ok, lets say on sheet 2 I have an inventory list. Colum1 has product name,
Colum 2 has Order #, and colum 3 has on hand qty. Now what I want to do is in sheet 1 be able to type a product name, and have it return to me the order #, and On hand qty. I know about ctrl-F, i dont want that. I want excel to return the info to sheet 1. Any suggestions??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find same numbers in a list in Excel | Excel Discussion (Misc queries) | |||
| find formula and return value | Excel Discussion (Misc queries) | |||
| Extracting/look up data from a list and select multiple instances | Excel Worksheet Functions | |||
| Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) | |||
| Returning the last item in column | New Users to Excel | |||
Threaded Mode
