Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This works quite nicely:
=INDEX('Price List'!$E:$J,MATCH($E20,'Price List'!$B:$B,0)+ROW()-ROW(),6) But the last cell reference of a value in column "6" in the above formula needs to be a calculated cell within this formula. In this case: F3*(1+I3) Reason being: It seems that the value in column 6 in the range is not present when the ODBC completes its job from which the data is extracted. I'm hoping that this calculation can occur in the cell where the above formula is located. So to summarize, can I replace the "6" in the above INDEX function with the result of calculating F3*(1+I3) ? TIA for any ideas. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELL Function: cell reference by formula | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
IF Function to test formula in a cell | Excel Worksheet Functions | |||
How to replace a function with its resulting reference in a formula? | Excel Worksheet Functions | |||
How to replace a function with its result or resulting reference in a formula? | Excel Worksheet Functions |