View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vikash Vikash is offline
external usenet poster
 
Posts: 2
Default How to use VLOOKUP function

Hi.........
i am facing some problem using VLOOKUP.
Actually i have two workbooks. one of them contains my client's account no.
and in other workbook, it contains account no., address & telephone no. of
clients. Now i want to use here vlookup to show me the address & telephone
no. of the clients according to account no. As in Workbook 2 contains some
extra client's account no. so i want to print only those address whose
account no. is available in workbook 2.
Hope anyone will solve my problem.
Thanks.