Menu

VLOOKUP? Or another function?

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

paul

Posts: n/a

Default

VLOOKUP? Or another function?

this sounds like you need dependent lists
courtesy Debra Dalgleish
http://www.contextures.com/xlDataVal02.html

--
paul

remove nospam for email addy!

"Jamie" wrote:

I am helping my friend develop a billing system for her small business. She
has a number of clients. Each client has a number of projects. At the moment,
her employees type in both the client name and the project name manually, but
this has led to confusion. The same project is called different things, etc.
Instead, we are trying to create a speadsheet so that when the user types in
a client name they can only then choose from a list of the projects
associated with that client. For example, Client A has two projects right
now, called Project 1 and Project 2. When the user types in Client A on the
billing sheet, then they can only select from Project 1 or Project 2 in the
next box. Is there a simple formula in visual basic or Excel to do this?
Please advise.
Thank you!

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup worksheet function	Antonis1234	Excel Worksheet Functions	3	November 6th 05 02:47 PM
Vlookup with function in table_array	JoshuaEyer	Excel Worksheet Functions	2	October 15th 05 03:49 PM
format cell based on results of vlookup function	Edith F	Excel Worksheet Functions	1	July 21st 05 07:39 PM
Vlookup w/Date Function	cym	Excel Worksheet Functions	1	March 25th 05 08:21 PM
Regarding IF function or vLOOKUP function	wuwu	Excel Worksheet Functions	2	November 13th 04 01:38 PM

All times are GMT +1. The time now is 02:37 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement