finding revision

[paul_aramis]

Hello everybody.

I need help again. I've tried every thing I could thought off, but I'm no Excel expert.
Please help me populate column B and C on 'Active parts! sheet with data (on column C) from column B on 'Existing GS! and (on column B) with data from 'Revision level! whenever the part number from 'Active parts! column A is found on 'Existing GS! and 'Revision level! A column's

[AYData]

You want Existing GS Col B to show data from Active Parts Col B using Col A match
You want Revision Level Col B to show data from Active Parts Col C using same match ?

[paul_aramis]

no, is the other way: 'Active Parts! has to be populated with data from the other two sheets columns B, when Col A 'Active Parts! is matching the others columns A.
Col B and C on 'Active Parts! are empty now.

[paul_aramis]

sorry, I just realize I made a mistake. I forgot that i have a current no. in sheet Existing GS. so Col C on Active Parts should take results from Col C on Existing GS when values from Col A Active Parts is matched in Col B Existing GS.
I found a formula, I' checking to see how is working. I'll be back.