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!
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,954
Messages
5,856,486
Members
431,817
Latest member
db74

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