How to constrain input to previous entries

  • Thread starter Thread starter SMUDGER
  • Start date Start date
S

SMUDGER

Hello every body, i am fresh in this forum so please help me out.I have
a sales report with entries that starts with customer names, data about
the specific deal and name of the sales rep.

What i need to do, is constrain each repetative customer to his
corresponding sales rep.So there must be something that I can do do the
sales rep column in my report that will make the cell prohibit the entry
of a different sales rep to a customer who was previously entered in the
report in correspondance to a different sales rep ( you can tell some
foul-play is happening in my company ;) ).

thanx
 
Use a VLOOKUP formula in the cell, and lock the cell to prevent over-writing it.

The formula would be along the lines of:

=VLOOKUP(Cell with customer Name,Range with old data, Column number within range of sales rep data,
False)
like, this in cell B100:
=VLOOKUP(A100,$A$1:A99,2,False)
with customer names in column A, reps in column B.

HTH,
Bernie
MS Excel MVP
 
Back
Top