Using VLOOKUP to Return Minimum Value in a Range of Calculated Cells

[KC_15]

Good afternoon,


I have a spreadsheet that I’musing to determine the most cost efficient options for running meetings at ouroffice. One of the criteria we are looking at is the most cost efficient optionfor AV equipment.


I would like to use VLOOKUP toprovide the minimum amount in column G. The values in column G are calculatedcells using the following formula: =SUM(C6,F6)*E6 (and so on and so on).


I would like cell A3 to returnthe most economic option from that range of data, however, at the moment I amusing VLOOKUP which is returning a value of #N/A: =VLOOKUP(MIN(G6:G11),C6:H11,5, 0).


Is there anyway to use VLOOKUPon calculated cells?


Thank you,

KC_15

 

[Zanjo]

I probably dont understand what you are after, but for me it sounds like you just want the smallest number in column G. Then you just type "=MIN(G:G)" in cell A3.
Could you explain more what you are looking to do? Maybe provite a screenshot of the sheet.