Forum Discussion
Excel - Return a specific text value, based on values of 2 other cells
Hello, I would be grateful if someone could help with a formula to accomplish the following: Based on combinations of the text values in cells A2 and B2, I would like C2 to return a specific text...
I couldn't resist this. I love HansVogelaar 's little table, so I created an unusual formula to exploit it!
= XLOOKUP(row, rowHeader, action)
XLOOKUP(column, columnHeader, action)
The first line picks out a row; the second a column. Putting them together returns the intersection of the two ranges.