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


Biff wrote:
Hi!

The short answer to your question is yes. Did you try it?

Don't know why you're using this:

+ROW()-ROW()

It's superfluous.

Biff

Biff, thanks for the sanity check. ;-)

The formula works well as =INDEX('Price List'!$E:$J,MATCH($E20,'Price
List'!$B:$B,0),6)
The next row is
=INDEX('Price List'!$E:$J,MATCH($E20,'Price List'!$B:$B,0)+1,6)
=INDEX('Price List'!$E:$J,MATCH($E20,'Price List'!$B:$B,0)+2,6)
etc.
however, we still need to multiply the value in column F by the value
in coulmn I at the row located by the INDEX/MATCH. This would appear
where a column 6 would be if it existed. Attempts at nomenclature have
fizzled in this heat.

Thanks for your interest.

Pierre