#1
|
|||
|
|||
How to update lastname with the help of V-Lookup formula?
Hi all,
I have 2 excel files. In the first excel first column, Dan Sara John In the second excel first column, Dan Wast Sara Marine Smith Disuzza I would like to update the last name in first excel on the basis of second excel matching first name. Output- Dan Wast Sara Marine Many Thanks. |
#2
|
|||
|
|||
See the attached.
|
#3
|
|||
|
|||
A good example why it is better not to store composite info in table. When you have separate columns for fore- and last names, you always can easily calculate full name, and you don't need to have complex formulas whenever you need some part on this full name instead.
In added file are formulas for case when name parts are on separate columns, and also when full name is used instead. |
#4
|
|||
|
|||
The right formulas are here! (The previous ones worked only until there were no gaps for matching names in sheet 2!)
|
#5
|
|||
|
|||
Please forget about #2.
|
#6
|
|||
|
|||
Many Thanks all of you for your efforts.
|
#7
|
||||
|
||||
Please mark "solved" if this answers your question. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter or Lookup Formula to Organize Keywords | MKTGCLOUD | Excel | 8 | 11-28-2018 07:35 PM |
Change "lastname, firstname" to "firstname lastname" Find & replace | delgesu | Word | 1 | 03-11-2018 10:20 PM |
Need help with lookup formula | tristanlau | Excel | 1 | 08-14-2017 07:16 AM |
Formula help please (lookup across multiple sheets) | froggybsb03 | Excel | 2 | 03-16-2017 02:16 AM |
lookup or filter data, update it and save it | fre_ | Excel Programming | 3 | 06-06-2016 08:54 PM |