Using index, match, and RIGHT,LEFT, or MID function together

[WisdomandLaughter]

I am using the following formula to pull information from one spreadsheet into another.

=IF(ISERROR(INDEX('Verizon Master'!I$10:I$70,MATCH($A3,'Verizon Master'!C$10:C$70,FALSE),1)),"",INDEX('Verizon Master'!I$10:I$70,MATCH($A3,'Verizon Master'!C$10:C$70,FALSE)))

The information being pulled is a telephone number and I only need the first three numbers/characters. I have used the LEFT function in the past however I'm not quite sure where to place it in the formula above.

Thank you for your help.

 

[DonkeyOte]

if you only need the 3 letters from the result (ie still match entire content) simply use

=LEFT(existing formula,3)

 

[WisdomandLaughter]

You rock! Thank you for solving my excel mystery for me.

Going forward I will have to try the obvious solution first.

Thank you for your help. Good luck on your job quest.