How to update lastname with the help of V-Lookup formula?

		Microsoft Office Forums > Microsoft Excel > Excel
How to update lastname with the help of V-Lookup formula?

FAQ

Thread Tools

Display Modes

12-04-2018, 05:28 AM

Mangesh1212 Mangesh1212 is offline

Windows 7 32bit How to update lastname with the help of V-Lookup formula?

Office 2007

Novice

Join Date: Nov 2018

Posts: 8

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

Sample.xlsx (9.6 KB, 12 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:37 AM.