Hey.
I have this database with about 3,000 data which includes numeric and words.
Every Month i get each individual in my team gets alloted a range of numerics + letters, or just a range of letters. Sometimes the range is just like Jorge gets range L-S and sometimes its like Sam gets a range of Alie-De
Im trying to make a search option, where i can any random issuer name in a cell, and it pulls up the name of the individual it was Assigned to.
I have attached the excel sheet for your reference.
The red box in Sheet 1 is where i would like to type in the name from the Database sheet and, it would pull up the name of the guy assigned to it.
Can Vlookup do this?
Bookmarks