If C contains specific STRING Switch Column A value with Column B Else Do nothing

**argou001** · 03-24-2021, 12:03 PM

Example in attached

If C contains specific STRING Switch Column A value with Column B Else Do nothing

**JohnTopley** · 03-24-2021, 12:45 PM

You cannot switch (by formula) unless cells in A and B are themelves assigned from other cells: so VBA is the only option

e.g

A2=H2 without Switch
B2=K2 without Switch

in A2

=IF(C2="Switch", K2,H2)

in B2

If)C"="Switch",H2,K2)

**FlameRetired** · 03-24-2021, 12:52 PM

Edited

I agree with John Topley about need for VBA. If A and B are assigned different cells this formula also works. In A8 then fill down and across to B11 this also works.

Formula:

Please Login or Register  to view this content.

	A	B	C
1	A-Apples	B-Bells	C-Comments
2	Granny Smith	Church
3	Alarm	Gala	Switch
4	Fuji	Bicycle
5	Class	Braeburn	Switch
6
7
8	Granny Smith	Church
9	Gala	Alarm
10	Fuji	Bicycle
11	Braeburn	Class

If C contains specific STRING Switch Column A value with Column B Else Do nothing

LinkBack

Thread Tools

Rate This Thread

Display

If C contains specific STRING Switch Column A value with Column B Else Do nothing

Re: If C contains specific STRING Switch Column A value with Column B Else Do nothing

Re: If C contains specific STRING Switch Column A value with Column B Else Do nothing

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Macro to find text string in one column and replace specific text in another column if

[SOLVED] Replacing specific text in string from same column...

[SOLVED] Vba code to concatenate a specific string to more than one column

[SOLVED] create a string of results from column A that have specific value in column b

How to search column of data for specific string and extract to new column

Date stamp if specific string in column A

Sorting Specific Character String in Column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions