=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,
FALSE),1,15))="applications",UPPER("Global
Trade"),IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)), "",MID(VLOOKUP(H3780,Tivol
i,4,FALSE),1,15)))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dmorri254" wrote in message
...
Hello,

I need some help with using the UPPER function....in this formula I need
to
convert the text "Global Trade" to upper case, where inside the formula do
I
place the UPPER funtion?


=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,
FALSE),1,15))="applications","Global

Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE))," ",MID(VLOOKUP(H3780,Tivoli
,4,FALSE),1,15)))

Thanx