There are four columns of numbers. I would like to have a formula that will look at the numbers in column A and find matches in columns B, C and D. If there is a match in A, then return the text "A", if the match is in B, return "B", if in D, return "D" if no match, then return nothing (or "0").
Anyone have a good way to do this? My attempts failed.
Many thanks.
Bookmarks