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?

VlOOKUP MIN value
Maj to min word - Guide
Conditional Formatting in a vlookup - Excel Forum
Vlookup to find missing data in 2 columns - Excel Forum
Vlookup date 1/0/1900 ✓ - Excel Forum
Opera min installing problem on gt-s3100 - Phones, PDA & GPS Forum

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

karbonn k10 password

Match partial text string in one sheet to another text string in another sheet

Concanating text using vlookup forumula

NFS Undercover Min Configuration

Similar discussions

Subscribe To Our Newsletter!