Matching 2 Lists with Data Verification

[Scott Sidoti]

I am creating a price quoting form for sales. I have all product models and their associated prices. I created a dropdown for list of products using data validation. So when someone chooses a certain product it should display the corresponding cost that is in a list in another column of same spreadsheet.

Example: There are 10 products in A1 - A10. The prices are in B1 - B10. So if I create a dropdown of products, when that product is chosen, say the one that was in A5, the price that goes with that, that was in B5 should display in another cell. I hope that's clear.

thanks,
Scott

[TMS]

Use VLOOKUP or INDEX/MATCH.