Hi,
I am trying to use vlookup to return a concatenation of first name , last name if the employee code given matches. The employee codes are available on both sheets whereas the firstname & last name are on different sheets.
I am using the above vlookup function. Could someone please point out where i am going wrong?
Please Login or Register to view this content.
Thank you.
The VLOOKUP search for values in the most left column of searching area. In your case is the last one. And the fourth argument need to be set as False(exact match) when searching for codes
First argument of VLOOKUP is OK. The second need to be a range who contains both columns : The searching column (Who need to be first in searching area) and the number of the return column. VLOOKUP returns the content of a cell from the search area. not a formula or whatever.
You can use a combination Of INDEX- MATCH
Formula:
Please Login or Register to view this content.
Last edited by tanasedn; 07-12-2021 at 02:30 AM.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
VLOOKUP works natively from left to right. Use INDEX MATCH instead:
=INDEX(Names!C:C&" "&Names!A:A,MATCH(Codes!A2,Names!D:D,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
move Employee Code to Column A
=VLOOKUP(A2,Names!A:D,2,FALSE) & " " & VLOOKUP(A2,Names!A:D,4,FALSE)
Thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks