INDEX function need to have col reference to be formula
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
|