adapting formula to not show OPP if empty

[swfarm]

hi guys

is it possible to amend this code - =IFERROR(VLOOKUP($L$2&CA8,Premier!$CG$2:$CH$381,2,FALSE),"")&" OPP "&IFERROR(VLOOKUP($T$2&CA8,Premier!$CG$2:$CH$381,2,FALSE),"")

if there is nothing it still shows the word opp which i dont want if it doesnt apply

[Pete_UK]

Basically, you will have to do:

=IF(your_existing_formula=" OPP ","",your_existing_formula)

Hope this helps.

Pete

[swfarm]

that doesnt work pete

[Pete_UK]

What does "doesn't work" mean?

Do you get some error message?

Pete

[swfarm]

i dont understand why it would be =" OPP "
it returns the answer false
where as if i leave it how it was it showed 2-0 OPP 3-1

[swfarm]

if both of the formulas = nothing then i dont want the word OPP in the cell

[Glenn Kennedy]

Try this:

=IFERROR(VLOOKUP($L$2&CA8,Premier!$CG$2:$CH$381,2,FALSE)&" OPP ","")&IFERROR(VLOOKUP($T$2&CA8,Premier!$CG$2:$CH$381,2,FALSE),"")

[Pete_UK]

Did you repeat the formula after the "", ?

The full formula would be:

=IF(IFERROR(VLOOKUP($L$2&CA8,Premier!$CG$2:$CH$381,2,FALSE),"")&" OPP "&IFERROR(VLOOKUP($T$2&CA8,Premier!$CG$2:$CH$381,2,FALSE),"")=" OPP ","",IFERROR(VLOOKUP($L$2&CA8,Premier!$CG$2:$CH$381,2,FALSE),"")&" OPP "&IFERROR(VLOOKUP($T$2&CA8,Premier!$CG$2:$CH$381,2,FALSE),""))

Hope this helps.

Pete

[KOKOSEK]

What about this

Please Login or Register  to view this content.

[swfarm]

thats done it.

Thanks Glenn Great stuff

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

[Pete_UK]

Hey Glenn,

I've just noticed that you are a Moderator now - congratulations.

Pete

[Glenn Kennedy]

A poisoned chalice... like Theresa May... but much less important!!