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!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
kweaver
Well-known Member
- Joined
- May 12, 2009
- Messages
- 2,934
- Office Version
- 365
- 2010
Welcome to the forum.
Have you tried VLOOKUP?
If you need help, please try to post a sample of your Sheet(s).
<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>
</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),"")
Have you tried VLOOKUP?
If you need help, please try to post a sample of your Sheet(s).
| Product | Price | Find | Price | |
| Apple | 10 | Banana | 30 | |
| Pear | 20 | |||
| Banana | 30 | |||
| Raspberry | 40 | |||
| Strawberry | 50 |
<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>
</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),"")
Last edited:
Upvote
0
