Hello.
I am trying to create an equation that can do a search of multiple columns and return the value from a single column that may be associated to another (for example, if I search columns A, B and C and find the matching value in column C, I would like to only return the associated value in Column A). I have attached an Excel file of example data and the format that it would be in. I understand that the explanation is a little confusing, so please let me know if further clarification is need.
Thanks in advance!
Bookmarks