Fill from price list

[Jillwill]

I have a sheet where column A is the product and column B is the price. I have a separate sheet with the price list. Column A has a drop box to choose a product from the list in the price list sheet. I'd like to price to automatically fill in Column B based on the value in Column A. I can't figure out what function/formula to use for this. Help!!

 

[kweaver]

Welcome to the forum.
Have you tried VLOOKUP?

If you need help, please try to post a sample of your Sheet(s).

Apple		Banana
Pear
Banana
Raspberry
Strawberry

<colgroup><col style="mso-width-source:userset;mso-width-alt:3657;width:75pt" width="100"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="width: 100"]Product[/TD]
[TD="width: 64"]Price[/TD]
[TD="width: 64"][/TD]
[TD="width: 98"]Find[/TD]
[TD="width: 64"]Price[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]30[/TD]

[TD="align: right"]20[/TD]

[TD="align: right"]30[/TD]

[TD="align: right"]40[/TD]

[TD="align: right"]50[/TD]

</tbody>

Where the "30" comes from a VLOOKUP of the value (e.g., banana) picked from the drop down: =IFERROR(VLOOKUP(D2,A2:B6,2,FALSE),"")