Simple drop down list validation

K

KerryOrr

Hi All,

I have two lists on one sheet, (Data), Services & Price.

In another sheet, (Invoice), I am using a drop down list for services,
and when a service is selected I would like it to automatically fill in
the price column.

I thought it would be simple but I seem to be getting the formula
wrong, can you help?

Many thanks!
 
P

Pete_UK

It always helps if you can give exact cell references where your data
is located, but in the absence of that it will be something like:

=VLOOKUP(A1,Data!A$1:B$100,2,0)

in B1 of your Invoice sheet. Assumes data occupies A1:B100 of Data
sheet, and that your drop-down is in A1 of Invoice sheet, so adjust
the references accordingly.

Hope this helps.

Pete
 
K

KerryOrr

Hi Pete,

Many thanks for your reply, that's a great help! All working fine now.

Very best wishes.

Kerry
 

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

Formula required for matching cells 2
Vlookup from a drop down list 2
Conditional data validation drop downs 2
Excel Excel: How do I put a formula in a drop down list 11
Drop down list 4
Building a Pricing Model 2
Data Validation to exclude blank cells 6
Drop Down List 3

Top