Thread: How to update lastname with the help of V-Lookup formula?
View Single Post
 
Old 12-04-2018, 05:28 AM
Mangesh1212 Mangesh1212 is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Nov 2018
Posts: 8
Mangesh1212 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Sample.xlsx (9.6 KB, 10 views)
Reply With Quote