Hello,
I have a spreadsheet showing the pricing of different products (Motorhomes)
Column A= Model
Column B= Chassis
Column C=Price
e.g.
motorhomeA Ford Transit $100,000
motorhomeA Mercedes $120,000
motorhomeA Fiat Ducato $115,000
motorhomeB Ford Transit $100,000
motorhomeB Mercedes $119,000
motorhomeB Fiat Ducato $113,000
On another sheet I have a summary page and want to lookup the model in the pricing sheet and return the cheapest (MIN) price for that model. Can anyone help?
Configuration: Windows Vista Internet Explorer 7.0
Hi,
|
Can i record more than 120 mins of video if this disc says 120 min Every time you enter a value into a cell in the worksheet, excel automatically Excel - search multiple columns to match a value then return data from row Excel find last active cell in column and return value in cell to left Excel formula display values in formulas Excel formula match 2 values Excel how to sum cell only if the value is greater Excel if then statement from drop down list value Find an text value in an excel range How to remove null values from list in excel If a column value is the same copy another column excel Incrase the sound value laptop Look for value in one sheet and printing in another sheet in excel Nec valuestar driver download Samsung p520 sar value Sony dvd 4.7 120 min keep saying playback limitation Usbstor values Vba excel checkbox set value to 1