View Single Post
  #4   Report Post  
hrlngrv - ExcelForums.com
 
Posts: n/a
Default

JE McGimpsey wrote...
...
Another:

=INDEX($A$1:$I$71, I78, COLUMN($I$1))

...

Depends on the range starting in column A. More robust to use

=INDEX($A$1:$I$71, I78, COLUMNS($A$1:$I$71))

to ensure referencing the rightmost column.
---------
www.coffeecozy.com

Use your Bodum and give up cold coffee for good!