I am working with teammate productivity numbers. We want to post how productive the teammates are, but we want to use a 4 digit number rather than their name.
In my attachment, columns A and B are the names and productivity for the teammates. E and G are the names and ID numbers I want to use.
In column C, I want it to say the Productivity ID number.
Please help!!!
=VLOOKUP(A2,$E$2:$G$35,3,0)
I hope this is what you want
hi stoudty, welcome to the forum. is this what you need?
=VLOOKUP(A2,$E$2:$G$35,3,0)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
WOW. That was fast. It works great. Thanks so much for the quick replys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks