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