VLOOKUP/MIN Problem

[sMart_D1006]

Evening all,

I am looking for some help please. I have searched and searched but I can not find the answer or figure it out.

OK, so i have two sheets with the same items, but different prices. In the second sheet I also want it to show me which price is cheaper, either the first or second sheet but must also search it but the item name is it may be in different rows per sheet.

I have attached an example of what I am looking to do with a brief description.

Hopefully someone can help me

Thanks
Mart

[ChemistB]

Try this in C1 copied down

Please Login or Register  to view this content.

[Sam Capricci]

you could try it this way (in the shop B column C1) =IF(VLOOKUP(A1,ShopA!$A$1:$B$5,2,FALSE)>B1,"ShopA","ShopB")

[sMart_D1006]

Fantastic, they both work perfectly

Thank you very much

[Sam Capricci]

you're welcome, glad to help.

[sMart_D1006]

OK, so after I have put the formula into my spreadsheet which is more complicated, i thought i would be able to adapt the formula to what I require. I've hit a brick wall I think its something to do with the columns.

I've attached a spreadsheet identical to the one i will be using.

Thank you, again

[63falcondude]

The first column of the VLOOKUP must contain the lookup value.

Since the lookup value is in column D, you can change ShopA!$A$2:$AA$21,23 to ShopA!$D$2:$W$21,20

[Sam Capricci]

this is what you should have in col X of ShopB instead... =IF(VLOOKUP(D2,ShopA!$D$2:$W$21,20,FALSE)>W2,"ShopA","ShopB")
you pointed the lookup part to the wrong range and used the wrong range and count over.
Hope that helps.

[sMart_D1006]

Thanks Sambo Kid. I was close, learning on the job thank you

[Sam Capricci]

You're welcome... again !