Hi everyone
If sheet 2 ID Number (A column) Match with Sheet 1 ID Number (A column) then put the name in name column (B column) of sheet 2 automatically.
Hi everyone
If sheet 2 ID Number (A column) Match with Sheet 1 ID Number (A column) then put the name in name column (B column) of sheet 2 automatically.
Last edited by sumanc6; 03-04-2016 at 03:18 PM.
assuming sheet 1 column A is ID number and Column B is the name then use this formula in sheet 2 cell B2:
=VLOOKUP(A2,Sheet1!A:B,2,FALSE)
Any other option or Formula???
why don't you post a sample worksheet so we have more ideas of what you are looking for specifically.
I am unable to upload attachment in forum thread.
Please find the link of sample file
http://we.tl/1PxDCjF3OP
In your workbook in sheet 1 ID column there is many spaces you have to do first trim that column after that do text to column......enter....enter...enter,
after that formula get work.
please see the attached file...
If answer helped you say Thanks by Add Reputation
There are any other option to work with untrimmed cell.
Actually I don’t need to any changed in sheet1.
Almost 35000 row in actual sheet1 & also contain many more data.
So please tail me any other formula, VB, Macro Etc…
Then Try this
=VLOOKUP("*"&A2&"*",sheet1!A:B,2,0)
see attached file.
Thank you
My problem now Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks