Lookup with phone number

**suganya.n** · 08-21-2012, 05:01 AM

hi i have a list of datas in the master sheet, when i enter a one data in the second sheet, i need all the remaining data which pertains to the keyword to be listed in the second sheet.

sample data is attached. if i enter the phone number in any place of the sheet, i require the corresponding datas of that phone number.

Please guide me

**Fotis1991** · 08-21-2012, 05:06 AM

=INDEX(Sheet1!A2:A8,MATCH(A1,Sheet1!F2:F8,0)

For the Company Name. Same for the others.....

**Ace_XL** · 08-21-2012, 05:07 AM

Use..

=INDEX($A$1:$F$8,MATCH($D14,$F$1:$F$8,0),1)

Adjust red highlighted number for subsequent columns

**suganya.n** · 08-21-2012, 06:40 AM

I am sorry I am unable to understand the formula, can u please brief me on this

**Fotis1991** · 08-21-2012, 07:25 AM

See here how this function works.

http://www.contextures.com/xlFunctions03.html

**suganya.n** · 08-21-2012, 07:52 AM

Thanks for your reply. I understood the sample link. But, my requirement is, if i type the phone number anywhere in the excel, then it should result me with the datas available from A2 to e2