Sorry Tim and Thank you. It probably would have worked if I actually went
into detail. But I thought I should make it short.

On my Period 1 worksheet I have the names on Column A but I have on Columns
C,D,E,F,G, H, I and J amounts but column K has the sum of that row.
The same for Period 2 worksheet.

Instead of me flipping back and forth from worksheets, I want to see the
names and sum amount for Period 1 and 2 in one sheet. I'm assuming I would
be doing a VLOOKUP on the Name but how do I get the sum amount for the name
appering beside the it for Period 1 and 2 ?

I hope I make sense.

"tim m" wrote:

You could even combine the VLookups in one cell if you choose. The formula
below subracts the 2nd sheet number result from the 1st sheet number result.

=VLOOKUP(A1,Sheet1!A1:C3,3,FALSE)-VLOOKUP(A1,Sheet2!A1:C3,3,FALSE)

"tim m" wrote:

In your 3rd sheet in column C you would have a formula like this:
=VLOOKUP(A1,Sheet1!A1:C3,3,FALSE)

This will look at the Name in your third sheet (A1), then it will look at
sheet 1 and search the range of data A1:C3 and return the value of the 3rd
column (your amount)

In your 3rd sheet in column D you would have a formula like this:
=VLOOKUP(A1,Sheet2!A1:C3,3,FALSE)

This does the same thing but you will note it is looking at Sheet2 rather
than sheet1

You can then just copy these formulas down as far as you need in your 3rd
sheet.

(In the sample above i only used 3 names and 3 values for the 1st two
sheets, obviously your data is probably larger.)




"julz" wrote:

Hi

I have in one worksheet in Column A Names and in Column C an amount for
period 1.
I have another worksheet in Column A Names and in Column C an amount for
period 2.

I want to create a worksheet with the Names in Column A but in column C I
want it to look up the name in period 1 and grab the amount and in Column D
look up the name in period 2 and grab the amount.
So I can calculate the difference with in the two periods.

I hope someone can help me ! Thank you