Excel 2007 : Macros or drop down lists?

**derek_koan** · 03-03-2010, 05:53 PM

I want to invoice my clients each month, and have a daily list of jobs completed for each client. each client seperate work book. to make invoicing and booking jobs in daily easier
I need a columb named Appliances and a second columb with £cost

When i type in appliances shortend code for various appliances EG: ura, study, tblock, etc I need the cost for that applince to be put in £cost columb.

how to achieve this? do I need macros or drop down lists? And can you point me in the direction of tutorial to achieve this?

I have no experience of excel and not shure if I am "up to it" I have downloaded excel for dummies but cant seem to figure what I need to do?

any help appreciated, thank you.

**jeffreybrown** · 03-03-2010, 05:59 PM

Hi & Welcome to the Board,

You might want to look at...dependent lists.

http://www.contextures.com/xldataval02.html

Sure miss read this one...thanks JB

**JBeaucaire** · 03-03-2010, 07:05 PM

I use INDEX/MATCH for this, but you can also use VLOOKUP() or LOOKUP() based on some other restrictions about the layout of the table you're searching. INDEX/MATCH has none of those restrictions.

Here's some sample sheets showing exactly what you're looking to do.
INDEX/MATCH Examples

The "Main" sheet on the INDEX-MATCH-Simple.xls shows the options best of all.

Excel 2007 : Macros or drop down lists?

LinkBack

Thread Tools

Rate This Thread

Display

Macros or drop down lists?

Re: Macros or drop down lists?

INDEX/MATCH explanation

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions