Hi Julie...
One more question....how can I use the UPPER function to make Global Trade
all upper case??

=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global
Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE))," ",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15)))

"JulieD" wrote:

Hi David

thanks <vbg glad it's solved .. and yep, it's bedtime now :)

Cheers
JulieD

"Dmorri254" wrote in message
...
EUREKA!!!!!! Girl you are just plain AWESOME!! never thought of that one
but
it works ...Thanx so much....

David

"JulieD" wrote:

Hi

try
=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global
Trade
SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15)))

- i'm thinking that this could be neatened up a bit but as it's 12.45am
my
brains too asleep to see it :) - let me know how you got with this ...

Cheers
JulieD
PS i prefer to use ISNA instead of ISERROR .. it isn't as all
encompassing
and doesn't hide "unexpected" errors.


"Dmorri254" wrote in message
...
Hi,

Let me explain further....L3780 contains this formula:
=IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15))

What it is doing is looking at another table and bringing me back some
text
I get form a query...now we are using a different system but I need to
merge
information form one system into this one...so in order to remain
consistant
with MY data, I need the word now used for Global Trade SV
(applications)
to
remain Global Trade SV....so this means in relation to the formula in
L3780
is this....TIVOLI,4 brings back Global Trade SV....so instead of
modifying
the formula, I can use a condition that says if applications is
returned,
replace it with Global Trade SV...

Does this help? If the existing formula can be modified then that would
be
even better...

Thanx

"JulieD" wrote:

Hi

not sure what you're after here, but a formula can not update another
cell -only the cell that the formula is in.

what is the formula in L3780 ... maybe we can alter this to show
Global
Trade SV instead of applications

Regards
JulieD

"Dmorri254" wrote in message
...
HI,

I want to say if L3780 = "applications", then replace it with
"Global Trade SV"

Since there is a formula in the field, I need to place this as a
condition...can anyone help me??

Thanx