Forum Discussion
Excel - auto-transfer data between column
Hello,
I have column A to G.
In the column B were listed first and the last names in alphabetical order.
In the column F the same first and the last names from column B were listed without any order.
Column C is empty. Column G have data related to the column F.
What I need?
I need the name from column B to be recognized from column F and the data from column G to be automatically assigned to the column C.
Please see the screenshot below.
From the screenshots: B1 to be recognized from F (in this case F7) and G7 to be automatically added to C1.
B2 to be recognized as F6 and G6 to be automatically added to C2.
The most important is data from column B to be recognized in F if that is possible.
Any help is much appreciated.
Thank you!
Hi Pedjony,
I think I got it (don't forget to change the formula to your language):
=vlookup(O9;S:T;2;False)
You just have to change the columns and thats it. Please tell me if I met your requirements
Best regards,
Schnittlauch"First, No system is safe. Second, Aim for the impossible. Third, no Backup, no Mercy" - Schnittlauch
My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved. 🙂
5 Replies
- Hi Pedjony,
I got a quick question, how many names do you have in column F on your productive excel?
Schnittlauch- Hi Schnittlauch,
Thank you for your reply.
In column F I have up to 400 names.Hi Pedjony,
I think I got it (don't forget to change the formula to your language):
=vlookup(O9;S:T;2;False)
You just have to change the columns and thats it. Please tell me if I met your requirements
Best regards,
Schnittlauch"First, No system is safe. Second, Aim for the impossible. Third, no Backup, no Mercy" - Schnittlauch
My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved. 🙂
