Match columns between sheets and use corresponding data

[SidVicious]

Hi!

First post here.

I have two sheets in the same workbook. On the first sheet, I have a list of numbers (Sheet1, Column A). On the second sheet I have a list of numbers (Sheet2, Column E) with first and last names (Sheet 2, Columns B & C) corresponding to the numbers in Column E. If the number in Sheet1,ColumnA matches Sheet2,ColumnE, I want to put the contents of the corresponding Sheet2, Column B & C info into Sheet1, Column B & C.

Please help.

Thanks!

[benishiryo]

hi SidVicious, welcome to the forum. maybe something like:
=INDEX(Sheet2!B$2:B$4,MATCH($A2,Sheet2!$E$2:$E$4,0))

or to handle errors, then
=IFERROR(INDEX(Sheet2!B$2:B$4,MATCH($A2,Sheet2!$E$2:$E$4,0)),"")

adjust the range to your needs

[SidVicious]

Thank you! Had to adjust for the list length and the sheet names, but worked like a charm.