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

On Oct 9, 10:55 am, KerryOrr
wrote:
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!

--
KerryOrr