Match/IF formula

[PJenkins]

Hello, I have two sheets to start every row on sheet 1 with an D in column A needs to be deleted (the entire row), then the numbers in column B I need matched with sheet 2 column D, If their is a match then would like the name on sheet 2 column E to be pasted to sheet 1 column J (in the corresponding row where the match was) In sheet "final" that is what I am looking for as far as a final product is concerned. Any help is greatly appreciated.

Thanks in advance
Pjenkins

[FrankBoston]

The following formulas may give you a start, along with the uploaded .zip

Please Login or Register  to view this content.