Need help to find formula to replace copy and paste when handling massive data

[DeeMak123]

Hello Guys I need help to copy information from one column to another using an appropriate excel formula. I want to do away using cut and paste methods because am dealing with lots of data hence want to save time. My excel skills are basic but catch up quickly. So a step by step guide will do the trick. thanks guys

here is a link to the screen shot https://www.filestofriends.com/share.aspx?code=5ad256a691c84ed6a4f1f44f1c471265

 

[ChrisFoster]

I might be missing the point of what you're trying to achieve, but in K4 put the below formula and the drag it to the rest of the cells you want it transferring to.

=F4

 

[DeeMak123]

Hello Chris thanks for replying I have attached a screen shot for clarity.
I am trying to use this formula =VLOOKUP($K$4,$F$4:$G$9,2,0) but instead of matching the data its duplicating. Am I missing something?


See Screen Shot
https://www.filestofriends.com/share.aspx?code=a5d0b1c57b1a4c9d9e718402ab9ee12a

 

[ChrisFoster]

Hello Chris thanks for replying I have attached a screen shot for clarity.
I am trying to use this formula =VLOOKUP($K$4,$F$4:$G$9,2,0) but instead of matching the data its duplicating. Am I missing something?


See Screen Shot
https://www.filestofriends.com/share.aspx?code=a5d0b1c57b1a4c9d9e718402ab9ee12a

Try this.

=VLOOKUP(K4,$F$4:$G$9,2,0)

Cheers

Chris