Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down need to validate information
Hi All, I have an spreadsheet with a drop down list ( I folow Debra guide to
create it), in total 4 columns Region Sales Rep Business Markets/Customer GNA cda Applications Electricity Once selected the region in the Sales rep column it will bring all the sales rep for that region, however if I select a region and sales rep and then come back and change the region and skip to change the sales rep, there is nothing that will stop me for doing it. I thought to enter a column that will lookup the sales rep into the GNA region and if then it doesn't match with Sales rep it will Highlight in red. I named the column for the regional sales rep in this case "GNAColumn". I am trying the formula =+VLOOKUP(E5,D5&"Column",1,FALSE), but it's bringing #VALUE. Can somebody help me with this then I will be able to apply the same logic to the other 2 Columns. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill in rows with Information from Drop Down list | Excel Worksheet Functions | |||
how do I create a drop down list that assigns certain information | Excel Discussion (Misc queries) | |||
Drop down list to enter information in the workbook | Excel Discussion (Misc queries) | |||
Validate drop down box | Excel Worksheet Functions | |||
How do you validate listed information with comment? | Excel Worksheet Functions |