ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Lookup Formula Assistance (https://www.excelbanter.com/excel-worksheet-functions/447702-lookup-formula-assistance.html)

matgriffey

Lookup Formula Assistance
 
1 Attachment(s)
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.


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com