one formula to pull all the information from sheet 1 to sheet 2

[share knowledge]

I am back after a long time with a tricky question

I have a spreadsheet in which sheet 1 has certain data s and sheet 2 with certain numbers.

Now i want a formula in the sheet 2 which pulls up the information from the sheet 1 for the reference number listed in the sheet 2.

I just need the information available in the column B,D and E and if the reference number in sheet 2 is not available in the sheet 1 i need NA

I actually tried VLOOKUP, but it pulls only set of info's and I have to put 3 vlook ups to pull data s.

So please give me one formula which pulls all the 3 info I required.

Thank You so much for all ur help
attaching the spreadsheet for your reference

[stanleydgromjr]

share knowledge,

See the attached workbook "Index Match 2 - Isna - share knowledge - SDG11.xls", Sheet2 formula beginning in cell B2.

Sheet2, range B2:D13, needs titles in row 1 for the following formula to work correctly:
=IF(ISNA(INDEX(Sheet1!$A$1:$E$1000,MATCH($A2,Sheet1!$A$1:$A$1000,0),MATCH(B$1,Sheet1!$A$1:$E$1,0),1)),"",INDEX(Sheet1!$A$1:$E$1000,MATCH($A2,Sheet1!$A$1:$A$1000,0),MATCH(B$1,Sheet1!$A$1:$E$1,0),1))

[share knowledge]

Thank You Friend. It worked. I really appreciate your efforts. Thanks Again.