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!
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!