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
|