The function you're looking for is called VLOOKUP. Assuming on sheet2 your
model numbers were in column A and prices in column B, and on Sheet1 your
model numbers are in column A, then in B1 of sheet1, put this formula and
copy down.........

=VLOOKUP(A1,Sheet2!A:B,2,false)

Vaya con Dios,
Chuck, CABGx3



"PaolaAndrea" wrote:

Good Morning everyone:

I have a column with a model number in one sheet and in another sheet I have
the same model number with the prices on it.

Is there a formula where I can tell the excel that If A in worksheet 1 = A
in worksheet 2 then B of worksheet 1 = b of worksheet 2.

Please help.

Sincerely,

PaolaAndrea