LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DKS DKS is offline
external usenet poster
 
Posts: 103
Default Intelligent VLOOKUP

I would like to program an intelligent Vlookup as follows.

I have a set of data spread over 2 columns. Let us say column A is type of
Food and column B is actual food-item.

for example, here is a short list
Column A Column B
Vegetable Potatoes
Fruit Orange
Fruit Banana
Vegetable Brocolli
Bakery Bread
Bakery Croissants
Vegetable Spinach
Fruit Grapes

I would like to program 2 drop-down lists with following requirements
The first list has as valid values all the FOOD types (thus Fruit,
Vegetable, Bakery).
The second list has as valid values all the items that are valid for the
selected item in first list. Thus if I select Bakery in drop-down list 1
then in list 2 I should see only Bread and Croissants as choices.

Any tips on how to achieve this? FYI: I can sort the data in any order if
that can facilitate the vlookup (or any other useful function).
 
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
VLookup a Vlookup adamb2000 Excel Worksheet Functions 4 June 28th 06 10:54 PM
VLOOKUP Problem Ian Excel Discussion (Misc queries) 3 April 6th 06 06:47 PM
VLOOKUP Limitations chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM


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

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

About Us

"It's about Microsoft Excel"