|I am trying to figure out if there is a way that an IF statement can populate multiple cells.|
Scenario: "Jones", "Thomas", "123 First Street", "Any Town', "Any State" is listed in a table in cells A1, B1, C1, D1 and E1, respectively, with similar lisitngs in cells A2:A10; B2:B10; C2:C10; D2:D10, and D2:D10. On a dfiferent worksheet, there are five cells for the five titles above, last name, first name, address1, city, and state.
I have been using an IF in each individual cell of the five cells to get the specified information. . Is there a way that one IF statement can populate all five cells?