LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CELL Function: cell reference by formula Alex C Excel Worksheet Functions 1 June 19th 06 03:30 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
IF Function to test formula in a cell Fred Holmes Excel Worksheet Functions 5 November 18th 05 12:04 AM
How to replace a function with its resulting reference in a formula? Dmitry Kopnichev Excel Worksheet Functions 7 October 13th 05 09:48 PM
How to replace a function with its result or resulting reference in a formula? Dmitry Kopnichev Excel Worksheet Functions 5 October 13th 05 12:15 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"