How do I pull data from another sheet (Sheet 2) into a column sheet 1 which matches data of another column

[mccartneyd1795]

Hi, I am an excel noob and I am having trouble explaining this through text haha, so sorry if this is simple.

I have cleaned (deleted hundreds of rows of useless data) information on an excel sheet and fixed names etc, I have then unfortunately deleted an important column. Due to the amount of work/time I have spent on the spreadsheet I am unable to start again.

Basically I need to fill column B in sheet 1 with the information from column B in sheet 2, as long as it matches column A in both sheet 1 and sheet2. I have put the unedited excel spreadsheet into sheet 2 of the spreadsheet I am working on, and hoping its a simple fix.

I have attached screen grabs of an example spreadsheet I have made- as you can see the rows of data for Kara (row 4), Tim (row 8) and Lisa (row 9) have been deleted in sheet 1.
Sheet 1

Sheet 2

Let me know if you need anymore information and thank you for your any help.

 

[Fluff]

How about

=INDEX(Sheet2!$B$2:$B$1000,MATCH(A2,Sheet2!$A$2:$A$1000,0))

 

[mccartneyd1795]

How about

=INDEX(Sheet2!$B$2:$B$1000,MATCH(A2,Sheet2!$A$2:$A$1000,0))
[/QUOTE]

How about

=INDEX(Sheet2!$B$2:$B$1000,MATCH(A2,Sheet2!$A$2:$A$1000,0))

Thank you, thats worked. Great help cheers.

 

[Fluff]

You're welcome & thanks for the feedback.