Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VLOOKUP? and Data Validation Combination

I have a challenge that I'm not sure can be done. I have a worksheet that
has a "main" column of data validation (list) and 4 other data validation
(list) columns are related to the "main" data validation. I have a datbase
that I want to use for something similiar to VLOOKUP to have these four other
data validation cells select to match the database selections of the "lookup
value" in the "main" cell. I then want to be able to change the data
validation selection of these four other cells by hand if I want to. Then
each time I select a new "lookup value" it will put the new values in the
other 4 data validation (list) cells

Hopefully this makes sense!

Kent
--
Thanks for the help (I need all I can get!)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Data Validation and combination UTResearchAnalyst Excel Worksheet Functions 3 July 11th 08 11:42 PM
Data Validation vs VLOOKUP - Linking to data in a seperate file Sharon Excel Worksheet Functions 3 May 15th 08 07:43 AM
Data Validation - combination of values Suzanne Excel Discussion (Misc queries) 3 January 3rd 07 01:11 AM
Combination of Validation List and VLOOKUP Problem Blake Excel Worksheet Functions 2 March 23rd 06 08:00 PM
data validation using vlookup cbra Excel Worksheet Functions 5 October 26th 05 12:24 PM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"