Hello, first and foremost, I've tried searching for this issue and I usually find what I need on the forums, but this one has me stumped.
What I'm trying to do is basically this:
I have a list of data in A1:A50 that has peoples first & last names. I'm using the ENVIRON("Username") command to retreive the name of the person who opens the workbook. Our office has it set-up so that it first letter of first name, full last name, so I'll use the mid function to remove just the last name, and then I want to take that last name, find it in the list of A1:A50, and then display the entire contents of whatever cell it's found in.
Basically, my excel sheet might look like:
(A1)From: John Smith
(A2)From: Jane Doe
(A3)From: Bob Thomas
The environ command will give me the value of "thomas", when Bob opens the sheet, and I want it then display "From: Bob Thomas", after it matches the last name to cell A3, I want it to display the contents of A3.
Would appreciate any help.
Thanks.
Bookmarks