Copy data that matches data from other worksheet

[Bikeman]

Hello,
Hoping someone can help with a formula.
On the attached workbook I’m trying to copy the part number from column C and the description from column A (from “PN’s IN BOM’s” sheet) that matches the entry in (sheet “BRV18150”). Once working I can carry it over to all the other sheets.

The entrees in column “A” on the “BRV18150” sheet will have a matching entry somewhere in column “B” on the “PN’s IN BOM’s” sheet. I would like a formula in column B and C on the “BRV18150” sheet that will look at column “B” on the “PN’s IN BOM’s” sheet, find a match and copy and paste the number from column “C” and the description from column “A” of the “PN’s IN BOM’s” sheet and paste to column B and C on the “BRV18150” sheet.

Hope this is not too confusing.

Thanks for any help with this.
Bikeman

[boopathiraja]

Hi, One way you can Consolidate multiple worksheets into one PivotTable report and apply filter, ref the attachment...

[kvsrinivasamurthy]

Pl see file.

[Bikeman]

Thanks! this is an interesting way of doing this.

[Bikeman]

This works perfect! thanks for the help.

[boopathiraja]

Hi, thanks for the feedback