Hi
I would appreciate help with this preferably as a formulae solution
Cells in Column I can be one of 4 letters - M,H,A or P
Cells in column M can be one of 12 words including the word "Past"
If a cell in column I is "P" then the corresponding cell in Column M must be "Past"
There are no restrictions on the values in Column I or Column M i.e. any of the remaining letters in column I (M,H and A) can be used with the remaining 11 words in Column M
Many thanks
Bookmarks