Return value in next cell

[tapsmiled]

Hi,
Can someone help me with a formula?
Sheet 1 column A is comprised of several items. Column B is comprised of their prices. If a value from column A is entered into D1, I want the corresponding price to appear in A1 on Sheet 2.

A B
apples $1.00
pears $1.50
banana $0.60
grapes $1.20

If "grapes" is typed into D1, I want $1.20 to appear on Sheet2!A1.

Can anyone help? Thanks in advance

[clabulis]

Put this in cell A1 on Sheet2 (you may need to replace the Sheet1! portions depending on the name of your first tab)

=VLOOKUP(Sheet1!D1,Sheet1!A1:B4,2,)

[tapsmiled]

I'll try it. Thanks!

[tapsmiled]

Worked perfectly. Thank you very much for your help!!