Hi,
Hope someone can help. I have a screenshot of my current workbook at:
https://www.dropbox.com/s/0qsfm7yfr4nwe56/EXCEL02.jpg?dl=0
The value in cell D19 is manually entered and can change periodically. I want a formula in cell A19 that will look the value in D19 against the values in cell range C1:C16 and then return the minimum value from cell B16 to whatever the corresponding cell between B1:B16 is. So for example, if I enter the value 27 in cell D19, then I would expect cell to find the lowest value between cells B8:B16. Therefore the value in cell A19 would return the value 200 as this is the lowest.
Hope this makes sense. This work is for a very good (not for profit) cause so any help would be MUCH appreciated.
I am using Excel 2013.
Thank you
Hope someone can help. I have a screenshot of my current workbook at:
https://www.dropbox.com/s/0qsfm7yfr4nwe56/EXCEL02.jpg?dl=0
The value in cell D19 is manually entered and can change periodically. I want a formula in cell A19 that will look the value in D19 against the values in cell range C1:C16 and then return the minimum value from cell B16 to whatever the corresponding cell between B1:B16 is. So for example, if I enter the value 27 in cell D19, then I would expect cell to find the lowest value between cells B8:B16. Therefore the value in cell A19 would return the value 200 as this is the lowest.
Hope this makes sense. This work is for a very good (not for profit) cause so any help would be MUCH appreciated.
I am using Excel 2013.
Thank you