Previous Topic Next Topic

VlOOKUP MIN value

Closed
Kate - Mar 25, 2009 at 12:23 AM
tinychok Posts 7 Registration date Thursday March 19, 2009 Status Member Last seen June 16, 2009 - Mar 25, 2009 at 06:37 AM
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?

1 response

Answer 1 / 1
tinychok Posts 7 Registration date Thursday March 19, 2009 Status Member Last seen June 16, 2009
Mar 25, 2009 at 06:37 AM
hi,
try this link to understand the VLOOKUP Function:
https://excel.tips.net/T002610_Understanding_the_VLOOKUP_Function.html

Similar discussions

Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
VlookUp Problem?
akram786 -
Mazzaropi -

1 response
karbonn k10 password
raj -
jack4rall -

1 response
Automatically transfer data from one sheet to another
sunny49er -
TrowaD -

22 responses
NFS Undercover Min Configuration
ivanalen -
kico -

5 responses