Sheet B (column A) will search for the phone number on Sheet A

[rionoah]

Sheet B (column A) will search for the phone number on Sheet A (column C) and display the text on column B (of sheet B)
ex

sheet A
A B C
apple angela 222-3323
banana brian 222-6621
cat carla 666-3333
dog denmark 222-4444
sleep englebert 666-8888

sheet B (SheetB-Column A will search for phone number on sheetA-column C and if found display contents on sheetA-ColumnB on sheetB-columnB )
A B
222-6621 brian
222-3323 angela
444-8888 <not found, don't display anything>
666-8888 englebert
667-0122
222-4444 denmark

[NBVC]

Try:

=IF(ISNUMBER(MATCH(A2,'Sheet A'!C:C,0)),INDEX('Sheet A'!B:B,MATCH(A2,'Sheet A'!C:C,0)),"")

copied down

[Ace_XL]

Use
=IF(ISNA(INDEX(SheetA!$B$2:$B$6,MATCH(A1,SheetA!$C$2:$C$6,0))),"",INDEX(SheetA!$B$2:$B$6,MATCH(A1,SheetA!$C$2:$C$6,0)))

For 2007 and later versions
=IFERROR(INDEX(SheetA!$B$2:$B$6,MATCH(A1,SheetA!$C$2:$C$6,0)),"")

[twiggywales]

Excel 2007+

Please Login or Register  to view this content.

excel 2003-

Please Login or Register  to view this content.

[rionoah]

can you code it again
compare (sheet B - column A) to (sheet A column D) for the phone number.
Then display the value of (sheet A - column C) on (sheet B - column B)

sheet A
...C......D
anna 222-3333
banana 777-8888
cat 666-0101


sheet B
...A..........B
666-0101 cat <-output
5445-8888 <blank, no match>
222-3333 anna <-output



Thank you

[NBVC]

Like so, in B2 of Sheet B...

=IF(ISNUMBER(MATCH(A2,'Sheet A'!D:D,0)),INDEX('Sheet A'!C:C,MATCH(A2,'Sheet A'!D:D,0)),"")

change Sheet A to actual sheetname if different.