Drop Down Menu - IF Formula

[WarrenCarr]

I want to have a drop down menu and if something is selected from that drop down menu to display only certain information. I have the drop down menu in place, but cannot figure out how to display correct information. i was tying to use and IF formula. But I don't know if this is the best approach or will work.

What I'm looking for is something like. IF drop down menu is "Setting 1" than display "this information". Any help or direction would be appreciated.

Thanks

 

[AliGW]

Where is the information being drawn from? If you create a lookup table, you could use VLOOKUP or INDEX MATCH. Perhaps if you show us the layout of your data?

 

[WarrenCarr]

So I have pages and I broke them down into the individual components for the most part. The main page is where I want the information to be displayed.

The main page basically just copies information from the account executive page, which pulls information from the account size page. The territory look up is where all the contact info is held. Unfortunately this was pulled from a different workbook which I don't have access to.

The short story is. I have sales guys who need to look up certain info and depending on different criteria, primarily how many units and territory location, they will be directed to different people. I had it set up well for our two main products. Residential and Commercial. But now I want to add on this drop down menu. So you would select the product from the drop down menu and it would display the appropriate contact information.

https://ibb.co/deo4mQ
https://ibb.co/mr560k
https://ibb.co/mdy4mQ
https://ibb.co/nCBqRQ
https://ibb.co/jkOR0k
https://ibb.co/nNDgY5
https://ibb.co/d0igY5

 

[AliGW]

What are all the links for?

 

[WarrenCarr]

screenshots of my excel. I didn't know if they would be useful. But I through them on

 

[FDibbins]

I cannot view images or go to file-hosting sites. Can you show (here) what you have, and what you want?

generally, to pull info based on a DD, you would use vlookup or index/match (to pull back only the 1st matching record)

 

[WarrenCarr]

Imgur: The most awesome images on the Internet - I don't know how to post pictures on here. But hopefully that link works.

 

[WarrenCarr]

So on the Main page. I want there to be a drop down. Depending on what that drop down was set on, I want it to show certain information.

For example. If there is no selection. Then you can enter information and it will give xyz information and what category the property falls into.
But if you select "drop down option 1" it would show abc information

 

[FDibbins]

As I have already said I cannot view images, not much point in adding more lol

Just copy/paste some sample data here

 

[WarrenCarr]

What do you mean sample data?
Like this?[TABLE="width: 579"]
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 5"]Account Executive LookUP[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Input Here[/TD]
[TD]Time Zone[/TD]
[TD]Account Type[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Drop Down - Search[/TD]
[TD]#N/A[/TD]
[TD]Commercial[/TD]
[/TR]
[TR]
[TD]Residential[/TD]
[TD] [/TD]
[TD]150[/TD]
[TD]Account Executive:[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]Commercial[/TD]
[TD] [/TD]
[TD]350[/TD]
[TD]Phone Number:[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]Zip[/TD]
[TD] [/TD]
[TD]5[/TD]
[TD]Territory:[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Global Sub Region:[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Manager:[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Manager Phone:[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]