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.

Hi Vikash,

Have a look at this link, it may help you

http://www.meadinkent.co.uk/xlvlookupmatch.htm

oldchippy ;)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569016