E
Eduardo
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
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