Hi All
Good morning!
I have a query. that I am having a some list of jobcodes in A column and the related team information is available in C column. Here for each job code we have numeric prefix ie., 1jon, 1pra, 2coy.... and the each prefix has assigned one team means 1-Black, 2-red. here my question is shall we print the team name in column C by using prefix at column A. please find the attached xls.
Thanks and regards.
Kiran
C2:
=VLOOKUP(LEFT(A2)*1,$G$2:$H$5,2,0)
and copy down
This pulls the first character of the string, multiplies it times 1 to make it a number, and then looks it up in G2:G5, and returns the respective value in the 2nd column.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Re: using prefix print the related information
Thanks, It's working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks