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
))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With The Upper Function 3
UPPER Function 1
Nesting A Function 3
Syntax Help 7
Converting Numeric values to Text 2
VLOOKUP and MID Function 9
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Combining two functions 13

Back
Top