View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default 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