So I am putting together a FMEA and want the values from column I and column J to be used to look up their intersection on a table and return a value in column M.
I thought about a index/match, but not sure how to do that, if column I has any "Letter" (A,B,C,D,E) and column J any "Numeral" (I,II,III,IV,V), take those identifiers and find the intersection in table and return the value of that intersects into column M.
Bookmarks