| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference cells in Functions
Here is my function
=INDEX('Downloaded Data'!$A$1:$H$495,MATCH(I1,'Downloaded Data'!$I$1:$I$495,0),3 This function is put into the Downloaded Data sheet via a VB procedure. I want "495" to be a variable, which comes from E11 on sheet1. I cannot get it to work. Please help Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need reference for max and [#this row] functions | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Need to reference existing functions in a custom function: possibl | Excel Worksheet Functions | |||
| Cells with functions. | Excel Worksheet Functions | |||
| How to reference unsaved workbook in functions???? | Excel Programming | |||
Threaded Mode
