Expert help needed please... Help file - Researched

[Kenny McCormick]

Ok. Here is my problem. I have a work book that I need assistance
with.

I need to compare data from two sheets within a worksheet. I then need
the B colum from both sheets to be subtracted and the difference
thrown on a thrid sheet within the workbook.
I hope this makes since... This should be easy, but i am having some
issues with it. Please see the examples i have inclosed.

Thanks for your help!!


EXAMPLE OF WHAT I CURRENTLY HAVE:

SHEET NAME: BATCHM

[ A ][ B ]
[1].54984-01 7
[2].54049-01 16
[3].54707-02 2
[4].58689-002 2
__________________________________

EXAMPLE OF WHAT I CURRENTLY HAVE:

SHEET NAME: INVEN
[ A ][ B ]
[1].54984-01 16
[2].54049-01 20
[3].54707-02 20
[4].58689-003 20

EXAMPLE OF WHAT I NEED FOR SHEET THREE: (The difference of the B
colums from both INVEN and BATCHM. IF THERE IS NO MATCH FOR THAT
NUMBER, MAYBE RETURNS A n/a?)

[ A ][ B ]
[1].54984-01 9
[2].54049-01 0
[3].54707-02 18
[4].54707-02 N/A


THANKS!!!

kENNY

 

[Harlan Grove]

...
...

I need to compare data from two sheets within a worksheet. I then need
the B colum from both sheets to be subtracted and the difference
thrown on a thrid sheet within the workbook. ...
EXAMPLE OF WHAT I CURRENTLY HAVE:

SHEET NAME: BATCHM

[ A ][ B ]
[1].54984-01 7
[2].54049-01 16
[3].54707-02 2
[4].58689-002 2
__________________________________

EXAMPLE OF WHAT I CURRENTLY HAVE:

SHEET NAME: INVEN
[ A ][ B ]
[1].54984-01 16
[2].54049-01 20
[3].54707-02 20
[4].58689-003 20

EXAMPLE OF WHAT I NEED FOR SHEET THREE: (The difference of the B
colums from both INVEN and BATCHM. IF THERE IS NO MATCH FOR THAT
NUMBER, MAYBE RETURNS A n/a?)

[ A ][ B ]
[1].54984-01 9
[2].54049-01 0
[3].54707-02 18
[4].54707-02 N/A

Clarification needed. The first line of the sample result makes sense,

INVEN!B1 - BATCHM!B1 = 9

Are these differences always INVEN less corresponding BATCHM values?

The second line of your sample result doesn't make sense. The column B value
should be 4, no? And there's no difference in A3 and A4 in the sample result
table, but the corresponding column B values differ.

Anyway, if it's always INVEN less BATCHM, and all necessary column A codes are
already loaded into column A (do you need help with that as well?), then if the
range in the INVEN worksheet were named InvenTbl and the range in the BATCHM
worksheet were named BatchMTbl, enter the following formula in cell B1 of the
worksheet containing the result table.

=VLOOKUP(A1,InvenTbl,2,0)-VLOOKUP(A1,BatchMTbl,2,0)

Fill down as needed.