Hello, I have two separate sentences written in two separate cells (A1 & B1). If in another cell the answer to a question is 'Client' or 'PDI' for example. I want a formula that will select the correct text from either cell A1 or B1.
i.e. 'Client' - Pulls text from A1. If PDI - Pulls text from B1
Solved by V. Y. in 14 mins