| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP, MATCH, INDEX HELP!
Here's what I'm looking at:
http://img148.imageshack.us/my.php?i...ventorymv7.jpg The left image is the summary page. I need a formula in the "Days Out" column that will look up data in the inventory sheet (right image) and pull the most current 'actual' inventory count and divide it by the average daily sales. Any ideas? Someone gave me a good LOOKUP formula, but it only worked horizontally and I need this to be vertical. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup or Index/Match | Excel Discussion (Misc queries) | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
| vlookup, match, index: all some or one? | Excel Discussion (Misc queries) | |||
| Vlookup or Index/Match | Excel Discussion (Misc queries) | |||
| vlookup, match/index ???? | Excel Worksheet Functions | |||
Threaded Mode
