Is there a way to have 3 seperate lists and have a formula look at each list. If specified text is found, depending on the list it will enter specific text.
Example
List 1 contains A, B, C if true enter a
List 2 contains D, E, F if true enter b
List 3 contains G, H, I if true enter c
Formula is looking at cell c3 and d3, if either cell contain any of those letters (A thru I), then the formula enters the text according to which list it found it in.
Bookmarks