Making Array Formula, please assist!

[Guest]

I need to make an array formula that compares prod id's from 2 worksheets
that are 4 digits long, then takes the value from the neighboring cell and
differences them and posts that result into a new cell. Any assistacne will
be greatly appreciated.

 

[Biff]

You need to be much more specific!

Biff

 

[Guest]

Thanks, Biff. Here's the deal:

I have 2 worksheets in the same workbook. I have data in both. I need to
take column 'A' from worksheet 2 and compare those to column 'A' in worksheet
1, if they are a match and no longer than 4 digits long, then column 'D' of
that row will be multiplied by -1, then added to column 'C' of worksheet 1 of
the corresponding row that was matched and the result placed into row 'E' of
worksheet 1 of the same corresponding row.

Clearer? LOL

That's what I need to do and I'm pulling my hair out!

 

[Biff]

That description does help but this is something I would need to actually
see to give the correct solution. If you can send me a copy of your file I'd
have a better idea of what you are wanting to do. If you can do that I'm at:

xl can help at comcast period net (remove can)

Biff