Request certain words to use a forumla

Mstg007

Active Member
Joined
Dec 30, 2013
Messages
383
Can you place a fomula that will only add quotes to a cell if the a Columns Cells exact text

line matchup?
B66="junction id" and E66=(i want the cell to the left D66 to have quotes).
B67="junction part" and E67=(i want the cell to the left D67 to have quotes).
.
B68="user sta" and E68=(i want the cell to the left D68 to NOT have quotes).
.
B162="junction id" and E162=(i want the cell to the left D162 to have quotes).
B163="junction part" and E163=(i want the cell to the left D163 to have quotes).
.
B164="user sta" and E164=(i want the cell to the left D164 to NOT have quotes).

For instance, I woud like to specify a formula that I can add varibles so it knows when to
activate or use the request.
I want the ("junction id" / "junction part") to have the quotes on because in column B it
found the exact text match.
But
the ("user sta") NOT to have the quotes because I did not request that value to have quotes.
The Idea is to place this formula on the top of a column and drag it down.
Thanks again!
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,462
Members
414,069
Latest member
StudExcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top