software

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

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
quot;PaolaAndreaquot; wrote:

gt; Good Morning everyone:
gt;
gt; I have a column with a model number in one sheet and in another sheet I have
gt; the same model number with the prices on it.
gt;
gt; Is there a formula where I can tell the excel that If A in worksheet 1 = A
gt; in worksheet 2 then B of worksheet 1 = b of worksheet 2.
gt;
gt; Please help.
gt;
gt; Sincerely,
gt;
gt; PaolaAndrea

My question was not clear enough. The model number are not in the same order
and some may not be in one of the sheets.

What I need is to have excel match the model number and then fill-in the
price.

for example:
Column A Column B Column C Column D
House House 100,000
Car Flight 800
Flight Car 90

I want have the formula match A to C and then insert the appropriate price
in D.

Is that Possible?

Thank you in advance for your help.

Gracias.
PaolaAndreaquot;CLRquot; wrote:

gt; The function you're looking for is called VLOOKUP. Assuming on sheet2 your
gt; model numbers were in column A and prices in column B, and on Sheet1 your
gt; model numbers are in column A, then in B1 of sheet1, put this formula and
gt; copy down.........
gt;
gt; =VLOOKUP(A1,Sheet2!A:B,2,false)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;PaolaAndreaquot; wrote:
gt;
gt; gt; Good Morning everyone:
gt; gt;
gt; gt; I have a column with a model number in one sheet and in another sheet I have
gt; gt; the same model number with the prices on it.
gt; gt;
gt; gt; Is there a formula where I can tell the excel that If A in worksheet 1 = A
gt; gt; in worksheet 2 then B of worksheet 1 = b of worksheet 2.
gt; gt;
gt; gt; Please help.
gt; gt;
gt; gt; Sincerely,
gt; gt;
gt; gt; PaolaAndrea

Using your sample data, the formula for B1 would be.....

=VLOOKUP(A1,C,2,FALSE)

This can be copied down column B for the other items in column A

Vaya con Dios,
Chuck, CABGx3
quot;PaolaAndreaquot; wrote:

gt; My question was not clear enough. The model number are not in the same order
gt; and some may not be in one of the sheets.
gt;
gt; What I need is to have excel match the model number and then fill-in the
gt; price.
gt;
gt; for example:
gt; Column A Column B Column C Column D
gt; House House 100,000
gt; Car Flight 800
gt; Flight Car 90
gt;
gt; I want have the formula match A to C and then insert the appropriate price
gt; in D.
gt;
gt; Is that Possible?
gt;
gt; Thank you in advance for your help.
gt;
gt; Gracias.
gt; PaolaAndrea
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; The function you're looking for is called VLOOKUP. Assuming on sheet2 your
gt; gt; model numbers were in column A and prices in column B, and on Sheet1 your
gt; gt; model numbers are in column A, then in B1 of sheet1, put this formula and
gt; gt; copy down.........
gt; gt;
gt; gt; =VLOOKUP(A1,Sheet2!A:B,2,false)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;PaolaAndreaquot; wrote:
gt; gt;
gt; gt; gt; Good Morning everyone:
gt; gt; gt;
gt; gt; gt; I have a column with a model number in one sheet and in another sheet I have
gt; gt; gt; the same model number with the prices on it.
gt; gt; gt;
gt; gt; gt; Is there a formula where I can tell the excel that If A in worksheet 1 = A
gt; gt; gt; in worksheet 2 then B of worksheet 1 = b of worksheet 2.
gt; gt; gt;
gt; gt; gt; Please help.
gt; gt; gt;
gt; gt; gt; Sincerely,
gt; gt; gt;
gt; gt; gt; PaolaAndrea

That was it.

Thank you so much.

quot;CLRquot; wrote:

gt; Using your sample data, the formula for B1 would be.....
gt;
gt; =VLOOKUP(A1,C,2,FALSE)
gt;
gt; This can be copied down column B for the other items in column A
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;PaolaAndreaquot; wrote:
gt;
gt; gt; My question was not clear enough. The model number are not in the same order
gt; gt; and some may not be in one of the sheets.
gt; gt;
gt; gt; What I need is to have excel match the model number and then fill-in the
gt; gt; price.
gt; gt;
gt; gt; for example:
gt; gt; Column A Column B Column C Column D
gt; gt; House House 100,000
gt; gt; Car Flight 800
gt; gt; Flight Car 90
gt; gt;
gt; gt; I want have the formula match A to C and then insert the appropriate price
gt; gt; in D.
gt; gt;
gt; gt; Is that Possible?
gt; gt;
gt; gt; Thank you in advance for your help.
gt; gt;
gt; gt; Gracias.
gt; gt; PaolaAndrea
gt; gt;
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; The function you're looking for is called VLOOKUP. Assuming on sheet2 your
gt; gt; gt; model numbers were in column A and prices in column B, and on Sheet1 your
gt; gt; gt; model numbers are in column A, then in B1 of sheet1, put this formula and
gt; gt; gt; copy down.........
gt; gt; gt;
gt; gt; gt; =VLOOKUP(A1,Sheet2!A:B,2,false)
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;PaolaAndreaquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Good Morning everyone:
gt; gt; gt; gt;
gt; gt; gt; gt; I have a column with a model number in one sheet and in another sheet I have
gt; gt; gt; gt; the same model number with the prices on it.
gt; gt; gt; gt;
gt; gt; gt; gt; Is there a formula where I can tell the excel that If A in worksheet 1 = A
gt; gt; gt; gt; in worksheet 2 then B of worksheet 1 = b of worksheet 2.
gt; gt; gt; gt;
gt; gt; gt; gt; Please help.
gt; gt; gt; gt;
gt; gt; gt; gt; Sincerely,
gt; gt; gt; gt;
gt; gt; gt; gt; PaolaAndrea

You're quite welcome.........happy to help.........and thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3
quot;PaolaAndreaquot; wrote:

gt; That was it.
gt;
gt; Thank you so much.
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Using your sample data, the formula for B1 would be.....
gt; gt;
gt; gt; =VLOOKUP(A1,C,2,FALSE)
gt; gt;
gt; gt; This can be copied down column B for the other items in column A
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;PaolaAndreaquot; wrote:
gt; gt;
gt; gt; gt; My question was not clear enough. The model number are not in the same order
gt; gt; gt; and some may not be in one of the sheets.
gt; gt; gt;
gt; gt; gt; What I need is to have excel match the model number and then fill-in the
gt; gt; gt; price.
gt; gt; gt;
gt; gt; gt; for example:
gt; gt; gt; Column A Column B Column C Column D
gt; gt; gt; House House 100,000
gt; gt; gt; Car Flight 800
gt; gt; gt; Flight Car 90
gt; gt; gt;
gt; gt; gt; I want have the formula match A to C and then insert the appropriate price
gt; gt; gt; in D.
gt; gt; gt;
gt; gt; gt; Is that Possible?
gt; gt; gt;
gt; gt; gt; Thank you in advance for your help.
gt; gt; gt;
gt; gt; gt; Gracias.
gt; gt; gt; PaolaAndrea
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; The function you're looking for is called VLOOKUP. Assuming on sheet2 your
gt; gt; gt; gt; model numbers were in column A and prices in column B, and on Sheet1 your
gt; gt; gt; gt; model numbers are in column A, then in B1 of sheet1, put this formula and
gt; gt; gt; gt; copy down.........
gt; gt; gt; gt;
gt; gt; gt; gt; =VLOOKUP(A1,Sheet2!A:B,2,false)
gt; gt; gt; gt;
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;PaolaAndreaquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Good Morning everyone:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a column with a model number in one sheet and in another sheet I have
gt; gt; gt; gt; gt; the same model number with the prices on it.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Is there a formula where I can tell the excel that If A in worksheet 1 = A
gt; gt; gt; gt; gt; in worksheet 2 then B of worksheet 1 = b of worksheet 2.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Please help.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Sincerely,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; PaolaAndrea