| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help doing a vlookup and average
Hi,
Right now I have two sheets, sheet 1 has a list of dates in column A (each date only listed once). Sheet 2 has individual purchases, with the dates in column A and the price in column B. Based on the date (listed in one cell) in sheet 1 i want to find the average price of all the purchases on that date in sheet 2 (listed in many cells). Right now, in sheet 1, cell B3, my formula is : =AVERAGE(VLOOKUP($A3,'Bond 1 Analysis (3)'!$A$3:$B$11357,2,FALSE)) I am getting a number (not "N/A", etc), but it is different than the average I got for the date when I did it manually to check. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of Vlookup data | Excel Worksheet Functions | |||
| vlookup then average 3 above and below | Excel Worksheet Functions | |||
| Combining Average, Offset & Vlookup | Excel Worksheet Functions | |||
| vlookup average() | Excel Worksheet Functions | |||
| Using VLookup, Displacement, SumIF to total and average | Excel Discussion (Misc queries) | |||
Threaded Mode
