View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JULZ JULZ is offline
external usenet poster
 
Posts: 7
Default how to do Vlookup on Multiple sheets on Excel ?

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