Simple drop down list validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KerryOrr - 09 Oct 2007 10:55 GMT

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!

Signature

KerryOrr

Reply to this Message

Pete_UK - 09 Oct 2007 13:08 GMT

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 <KerryOrr.1511...@officefrustration.com>
wrote:

> Hi All,
>
[quoted text clipped - 11 lines]
> --
> KerryOrr

Reply to this Message

KerryOrr - 09 Oct 2007 20:45 GMT

Hi Pete,

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

Very best wishes.

Kerry

Pete_UK;2412673 Wrote:

> 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:
[quoted text clipped - 28 lines]
> --
> KerryOrr-

Signature

KerryOrr

Reply to this Message

Pete_UK - 09 Oct 2007 23:54 GMT

Glad to be of help, Kerry - thanks for letting me know.

Pete

On Oct 9, 8:45 pm, KerryOrr <KerryOrr.151a...@officefrustration.com>
wrote:

> Hi Pete,
>
[quoted text clipped - 43 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: