| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to return an address from a lookup into a table?
In my workbook, one worksheet (Tab1) should contain several formulas
structured as: =AVERAGE('Tab2'!Address1:Address2) The other worksheet (Tab2) contains a table, in which column A are all dates from the last 5 years, in ascending order, and column B the corresponding target values. Address1 and Address2 are the cells in column B of Tab2 located on the same rows as the cells in column A that contain Date1 and Date2, respectively. Date1 and Date2 are cells (containing dates) in Tab1. My goal is to have each formula in Tab1, given Date1 and Date2, calculate an average of target values retrieved from the table in Tab2. How should I complete the formulas? Should a Lookup function be used? Many thanks. Chap |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
| Lookup, and Return Cell Address | Excel Worksheet Functions | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
| V Lookup and return cell address | Excel Worksheet Functions | |||
| need Lookup table to return null or zero | Excel Worksheet Functions | |||
Threaded Mode
