How to do Vlookup and MIN

[Miiya]

Hi

I would like to ask one question about excel as i have a list of item that I'm selling in a different price i would like to capture the lowest price that was given already how do i do that?

As i only know how to use vlookup and my formula is this =VLOOKUP(I2,B2:C43,2,FALSE) // What i would like to do is to take the lowest price for lamp which is 32.00 to be capture

 

[arthurbr]

Perhaps

 = MIN(IF($b$2:$b$100=$i2,$c$2:$c$100,""))

and pull down

 

[Miiya]

Hi!

Thank for your reply

I tried your formula =MIN(IF($B$2:$B$100=$I$2,$C$2:$C$100,"")) but my value is 1

 

[arthurbr]

replace $I$2 in your formula with $I2 and commit the formula as an array formula with Ctrl+Shift+Enter

 

[Peter_SSs]

Welcome to the MrExcel board!

Another option that does not require the Ctrl+Shift+Enter confirmation is ..

=AGGREGATE(15,6,C$2:C$43/(B$2:B$43=I2),1)