I attached a file with 2 tabs. The first tab has a list of customer names and their assigned salesperson. The second tab has a dropdown list of the customers in column a. I want column d to automatically fill in the salesperson's name based on the value of column c (which is the result of the dropdown list). Since I have hundreds of customers and always adding more, the if/then would be may to complex. Any suggestions? Thanks!
Sounds like vlookup should do it. But having trouble with your attachment right now..
Something like this in column D of the second tab
=VLOOKUP(A2,'first tab'!A:B,2,FALSE)
Where the first tab has the customer names in column A, and SalesPerson in column B
Hi,
I can't see any attachment yet...
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There's no file attached, but Vlookup formula should be able to handle that.
David
(*) Reputation points appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks