WisdomandLaughter
New Member
- Joined
- May 28, 2008
- Messages
- 35
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.
=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.