View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tran1728 tran1728 is offline
external usenet poster
 
Posts: 28
Default Vlookup for 3 sheets

Dear All, pls help me.
I want to make a Vlookup, the data of Product est very big, Column A is
Item, Column B is Description, there have 3 Sheets for product ( Product01,
Product02 and Product03 ) .

I know just to do for Product01.
=VLOOKUP(A1,Product01!A:B,2,FALSE)

Pls help me the formula also for Product01!A:B, Product02!A:B and
Product03!A:B

Thanks so much.