Replacing a cell in a formula by an other

1. Replacing a cell in a formula by an other

Here's my problem. I have several long formulas that I need to adapt one by one in order to obtain the desired result. Here is an example of a formula using "IF" (which is "SI" in French).

=SI(C33=1;\$TM\$26;SI(C33=2;\$TM\$27;SI(C33=3;\$TM\$28;SI(C33=4;\$TM\$29;SI(C33=5;\$TM\$30;SI(C33=6;\$TM\$31;SI(C33=7;\$TM\$32;SI(C33=8;\$TM\$33;SI(C33=9;\$TM\$34;SI(C33=10;\$TM\$35;SI(C33=11;\$TM\$36;SI(C33=12;\$TM\$37;SI(C33=13;\$TM\$38;SI(C33=14;\$TM\$39;SI(C33=15;\$TM\$40;SI(C33=16;\$TM\$41;SI(C33=17;\$TM\$42;SI(C33=18;\$TM\$43;SI(C33=19;\$TM\$44;SI(C33=20;\$TM\$45;SI(C33=21;\$TM\$46;SI(C33=22;\$TM\$47;SI(C33=23;\$TM\$48;SI(C33=24;\$TM\$49;SI(C33=25;\$TM\$50;SI(C33=26;\$TM\$51;SI(C33=27;\$TM\$52;SI(C33=28;\$TM\$53;SI(C33=29;\$TM\$54;SI(C33=30;\$TM\$55;SI(C33=31;\$TM\$56;SI(C33=32;\$TM\$57;SI(C33=33;\$TM\$58;SI(C33=34;\$TM\$59;""))))))))))))))))))))))))))))))))))

In this fomula, I wish to modify all the "TM" into "UF" without having to manually change them one by one. Is there a speedy way to do this? Thanks!

2. Re: Replacing a cell in a formula by an other

Hi,

Yes, this can be done with a Find and Replace.

Find what: \$TM\$
Replace with: \$UF\$

3. Re: Replacing a cell in a formula by an other

Cool! I'll try this out later this evening. Thank you for your reply (you have just saved me a whole lotta work)! THANKS!

4. Re: Replacing a cell in a formula by an other

reading your question I think you also have to take a look at Vlookup, since your used 33 or 34 if statements.

without seeing a small part of the excel file, without confidential information it is hard to advice for your situation.

5. Re: Replacing a cell in a formula by an other

@oeldere makes an excellent point. You would be better served with using VLOOKUP.

See attached example.

6. Re: Replacing a cell in a formula by an other

..or perhaps even simpler

Formula:
`Please Login or Register  to view this content.`

7. Re: Replacing a cell in a formula by an other

I'm familiar with VLOOKUP. And yes, it could be used as an alternate way to run my program. However, I'm not familiar with the INDEX formula. I'll look into it.

Also, I tried FIND AND REPLACE earlier this morning... YEAH BABY!!! It works real nice! I knew there was a simplier way to get things done, I just didn't know how. Many thanks to SOUTHWARD!

8. Re: Replacing a cell in a formula by an other

You're welcome. We appreciate the feedback!

In the menu bar above the very first post select Thread Tools, then select 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 those who helped you reach a solution.

9. Re: Replacing a cell in a formula by an other

Glad I could be of some assistance

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

X vBulletin 4.1.8 Debug Information

• Page Generation 0.06876 seconds
• Memory Usage 9,107KB
• Queries Executed 16 (?)
Template Usage (34):
• (1)footer
• (1)forumrules
• (1)gobutton
• (9)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (1)postbit_attachment
• (9)postbit_legacy
• (9)postbit_onlinestatus
• (9)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (49):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• bbcode_parse_start
• postbit_imicons
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• postbit_attachment
• tag_fetchbit_complete