Making Array Formula, please assist!

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.

You need to be much more specific!

Biff

"Macinslaw" <[email protected]> wrote in message
news:[email protected]...
>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.

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" wrote:

> You need to be much more specific!
>
> Biff
>
> "Macinslaw" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>

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

"Macinslaw" <[email protected]> wrote in message
news:[email protected]...
> 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" wrote:
>
>> You need to be much more specific!
>>
>> Biff
>>
>> "Macinslaw" <[email protected]> wrote in message
>> news:[email protected]...
>> >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.
>>
>>
>>