Hi guys
The problem which i am facing with the INDEX/MATCH function is that i want to check several columns at once for a certain value.
The function in the example checks the H column for EMP_ID values.
The column containing EMP_ID values however changes between G and H for different data sets.
Is it possible to create a function which checks both columns?
Theishv
The problem which i am facing with the INDEX/MATCH function is that i want to check several columns at once for a certain value.
The function in the example checks the H column for EMP_ID values.
The column containing EMP_ID values however changes between G and H for different data sets.
Is it possible to create a function which checks both columns?
Theishv
Last edited: