Forum Discussion

Copper Contributor

Jun 16, 2021

Solved

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 withou...

data

excel

Schnittlauch
Jun 16, 2021
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. 🙂

Pedjony

Copper Contributor

Jun 16, 2021

Hi Schnittlauch,

Thank you for your reply.

In column F I have up to 400 names.

Schnittlauch

Iron Contributor

Jun 16, 2021

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. 🙂

Pedjony
Copper Contributor
Jun 16, 2021
Dear Schnittlauch,

You are a lifesaver 🙂
This works like a charm.

I really appreciate your help.

Thank you very very much!
- Schnittlauch
  Iron Contributor
  Jun 17, 2021
  Haha no problem, you are welcome ❤️