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