Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 6
Default Lookup Formula Assistance

Good morning
I have posted other requests and been given help so hope someone can help me decipher this question.

The goal I am trying to accomplish is having a list produce results based on an Index formula's results.

I have DIV and PLAN feeding the BILLTO and INVOICE LEVEL cells respectively. What I am attempting to add is that when the INVOICE LEVEL = PLAN, the PLAN TO BILL cell has a drop down which allows the user to select the plan they need from the CLIENT PLANS worksheet. I would like the same to happen if the INVOICE LEVEL = AGROUP, the group drop down to give a list of Groups from the Client Groups worksheet.

I attempted to use the following formula, but am told the formula is invalid to make a list.
=if(b4="PLAN",(vlookup(b3,PlanList,2,false)))
The formula DOES work to bring one result when in the actual cell, but I need it to produce a drop down list.

Please let me know if there is a way to get this to work for making a list, and if anything else is needed, please let me know.

Thank you very much for any assistance that can be provided.
Attached Files
File Type: zip Help Test2.zip (51.3 KB, 55 views)
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
Lookup assistance needed HowardM Excel Worksheet Functions 9 December 9th 09 06:13 PM
lookup assistance theredspecial Excel Worksheet Functions 1 December 11th 07 12:23 AM
Lookup function assistance erajim Excel Worksheet Functions 2 December 23rd 06 06:39 AM
Lookup Assistance Tiffany Excel Worksheet Functions 7 February 28th 06 10:19 PM
need assistance with some find or lookup related code... hshayh0rn Excel Programming 5 January 4th 06 12:00 AM


All times are GMT +1. The time now is 06:13 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"