Forum Discussion
USE A NAME FROM A TABLE
1. A line refers to an event. I have 2 conditions:
a. 2 cells of the line have 2 different type of numbers
b. The combination of those 2 numbers according to their range, puts them in a category as defined in a table on another sheet.
c. How do I name them automatically by reference this type of categorization on the table for subsequent lines?
13 Replies
This is a guess at what you require but, if the values 'typeA' and 'typeB' are looked up as the row and column headers of the 'category' table, categories may be returned using
= INDEX(category, XMATCH(typeA, listA, -1), XMATCH(typeB, listB, -1))
Can you solve the issue under the "TEAM", so that I know what it is under the conditions below?
Thanks in advance!
Apo
