using a cell reference in another cell inside min function

[Brian Tucker]

I have a cell reference generated by the vlookup function that I want to
use inside the min function. Is there a way to do the following:
min(b19:the value of another cell(which is a cell reference))? Any
ideas?

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank kabel]

Hi
try:
=MIN(INDIRECT("B19:" & cell_reference))