pick from list and automatically enter corresponding cell

B

Bremser

I'm trying to create a simple product order form. I'm only using a single
workbook with 2 sheets w/o any external sources of data. I have my product
selections and their corresponding pricing in 2 adjacent columns in the
second sheet of my workbook. I have a dropdown menu (page 1 in this same
workbook) for selecting the
product choice, and I want the corresponding price in the cell adjacent to
that product to automatically populate on the order form. I've tried LOOKUP,
VLOOKUP, and MATCH formulae functions w/o success. It can't be that
complicated, can it?!

Your help and suggestions are much appreciated in advance.

B
 
G

Gord Dibben

Assume your two columns of data are products in A1:A50 and prices in B1:B50

In A1 you will enter a DV dropdown list with the products.

In B1 you have this formula

=VLOOKUP(A1,Sheet2!$A$1:$B$50,2,FALSE)

Pick a product from the A1 dropdown and the price will show in B1.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pick from list and automatically enter corresponding cell 1
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Cell values to an array, then array transpose to another workbook 8
Copy and shift data automaticaly 0
Emailing a sheet from a workbook with VBA 0
vba to copy data from sale receipt to next available column in an inventory worksheet 0
vba to copy data from sale receipt to next available column in aninventory worksheet 0
Unable to display values in 2nd list box from 1st list box selection 2

Top