| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i retreive data from another worksheet to a current one?
I am making a master pricing worksheet catalog. I am purchasing the same
products from mulitple vendors, all use the same product code as well. I have set up 3 different vendors to compare prices on items. How do i put a formula together on my master worksheet to scan these other 3 worksheets that are identical to where i can have my master worksheet return the lowest price? So if I type in product #1234 in the master sheet it will look at Sheet 1:3 and return the lowest priced product? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
| Look up Data from Worksheet within same Workbook | New Users to Excel | |||
| Retreive data from another worksheet based on multiple columns | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Threaded Mode
