I need to be able to locate a telephone number within a file and have it return the name of the owner (Column A). I have a column of phone numbers in one sheet, and a phone list in another sheet.
I need help creating an array with match and index and have the formula return the name of the person with that phone number.
i can upload or share the file.
Thanks
Hi Welcome to XL forum
Yes please attach the workbook.
Go to advance and click on attachment link and attach the workbook
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
see attached
I want to update 'Gmail contact lines' column B with 'all list' column A,
Try
B1=IFERROR(IFERROR(IFERROR(INDEX('all list'!$A$2:$A$6,MATCH(A1,'all list'!$AV$2:$AV$6,0)),INDEX('all list'!$A$2:$A$6,MATCH(A1,'all list'!$BA$2:$BA$6,0))),INDEX('all list'!$A$2:$A$6,MATCH(A1,'all list'!$BB$2:$BB$7,0))),INDEX('all list'!$A$2:$A$6,MATCH(A1,'all list'!$AD$2:$AD$6,0))) and drag down
This is great for few columns. But if I need to check in all columns I will be better with array
try
B2=INDEX('all list'!$A$2:$A$6,SMALL(IF('all list'!$B$2:$CH$6='Gmail contact lines'!A1,ROW('all list'!$A$2:$A$6)-ROW('all list'!$A$2)+1),1)) with CRTL+SHIFT+ENTER and drag down.
This is an array formula which need to confirm with CRTL+SHIFT+ENTER. See {} these brackets start and with end .
Last edited by shukla.ankur281190; 02-01-2016 at 04:08 AM. Reason: Text missings
Hi
Put below formula in B1 & drag down
Formula:
Please Login or Register to view this content.
Cheers!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks