Pulling info from one column to a different sheet

[thezwashere]

Hi all,

Quick question....So I have two sheets. I need a formula to pull Column A info from Sheet 1, to COlumn B of Sheet 2. Is it Vlookup? Or something else? Having trouble getting it to work.

Thank you!

Sheet 1

Column A Column B
Linkedin Social Media
Indeed Job Board
Career Fair University Recruiting


Sheet 2
Column A Column B
Social Media ????
Job Board
University Recruiting

 

[Ramballah]

You can always do =Sheet1!A1 and autofill it

 

[thezwashere]

Hi,

Oops, maybe my first post wasn't clear enough.
Sheet 1, Column A contains hundreds of sources, then Column B contains the grouping for the sources. On Sheet 2, I need Column B to automatically fill the sourcers, by reference the correct grouping as shown in Sheet 1. So I don't think autofill will work.

Sheet 1

Column A Column B
Linkedin Social Media
Indeed Job Board
Career Fair University Recruiting


Sheet 2
Column A Column B
Social Media (For example, need it to automatically fill in) Linkedin
Job Board
University Recruiting

 

[Ramballah]

dunno then XD