how to get data in sheet2 from sheet1 in excel

Posted by romen-leung on Stack Overflow See other posts from Stack Overflow or by romen-leung
Published on 2010-01-29T02:53:08Z Indexed on 2010/04/18 19:03 UTC
Read the original article Hit count: 576

Filed under:
|

I have two worksheets,

Sheet1
Column A = Deptname
Column B = Headname
Column C = Username

Sheet2
Column A = Headname (???)
Column B = Username
Column C = UserID

"Headname" column in Sheet2 is blank and what I wanted to do is to get "Headname" from Sheet1 by using "Username".

I have tried to use VLookup but it did not work if username in Sheet1 and Sheet2 is not exactly same.

E.G, given two differents Username as shown on below.

  • Username in Sheet1 is "Jenny Oh" and "Chan Shu Mei"
  • Username in Sheet2 is "ITC - Jenny Ong" and "IA: Chan Shu Mei"

Any ideas whether it can be done? Thankf in advance for any help.

© Stack Overflow or respective owner

Related posts about excel-formula

Related posts about excel