Compare cells in two colums from sheet 1 to sheet two, if they match, copy text from colum 3

[jason72670]

I have two sheets with three columns each. In column a of sheet 1, I will input names. In column b of sheet 1, I will input products. In column a of sheet 2, I have names. In column b of sheet 2, I have products. In column c of sheet 2, I have prices. I am using Sheet 1 as a daily monitoring sheet. Sheet 2 will be a master sheet where as prices change, I can correct the prices and it will be protected. I would like to be able to enter a name in column a of sheet 1 and a product column b of sheet 1 and find the corresponding match in columns a & b of sheet 2 and copy the price from that corresponding row from column c of sheet 2 to column c of sheet 1.

sheet 2

a b c
1 Harps Cookies $2.99
2 Toms Chips $0.99
3 Hormel Ham $5.99
4 Dawn Soap $4.19
5 Rudd Paint $4.25
6 Bush Beans $0.99



sheet 1

a b c
1 Dawn Soap
2 Bush Beans
3 Hormel Ham
4 Rudd Paint
5
6

 

[RudiS]

This should work...

Add a column to sheet 2 and concatenate the Name and Product

See: Sheet 2

This use a VLOOKUP in sheet 1 to collect the prices

See: Sheet 1