Thread: comparing lists
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
mubashir aziz[_7_] mubashir aziz[_7_] is offline
external usenet poster
 
Posts: 1
Default comparing lists


brian;337500 Wrote:
I have two lists with names and phone numbers. How can I search one
list
against the other for all the matching records?


you can use vlookup or Index/match to sort out the problem .......
but sample sheet will be more helpful to guide you properly


--
mubashir aziz
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94381