Combining Functions

  • Thread starter Thread starter David M
  • Start date Start date
D

David M

Please help.....

=IF(ISERROR(VLOOKUP(G4,Tivoli,5,FALSE)),"",VLOOKUP
(G4,Tivoli,5,FALSE))

returns the word Infrastructure......


I want to use the mid function to return an abbreviated
form of this word combined with the above IF statement.

Example =MID('Tivoli Db Query'!E2,1,5) returns Infra


How do I include the MID function into the IF statement
above??
 
Perhaps:

=IF(ISERROR(VLOOKUP(G4,Tivoli,5,FALSE)),"",MID(VLOOKUP(G4,Tivoli,5,FALSE),1,
5))
 
Hi
Try this:
=IF(ISERROR(VLOOKUP(G4,Tivoli,5,FALSE)),"",LEFT(VLOOKUP(G4,Tivoli,5,FALSE),5
))
 
Back
Top