• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula for showing initials

S

Shazz

Member
Hi All,

I have a spreadsheet (Order Form), in C44 you cn choose a persons name, and I want once the name has been chosen, Lets say Joe Bloogs, in B10 I want BJ to display, I have on tab 2 (Signatures) names of the people in column A and the Initials in column B, I just dont know how to use this all the get what I want.

Can anyone help me please,

Shazz xx
 
If column A is Names & column B is initials that means you already have names & initials as a dataset right? So you just want to display the initials in sheet1 C10 when you choose Name in C44? Use vlookup
 
You must log in or register to reply here.
Back
Top