Hi,
I'm trying to find a solution for an excel function in which I need to locate the column number based on a specific value match within an array. Normally I would use the Index Match function but the tricky thing is that within the array, the same value can appear in multiple rows and I have to find first identify the specific row number and then the specific column number based on two different identifying values. I do have a match function created to locate the specific row but wasn't sure how to then combine that in a function to then locate the column number of a specific value in that same row. In total I have 20 rows and 10 columns with similar values in each row but all of the values within a single row are unique.
As an example, In row 2 I have values of 0,2,1,00 and in row 3 I have values of 1,3,0,2. I have first created a Match function to identify that I need to look in row 3 but how can I come up with a function to say find the column number in row 3 that contains the value of 2 (which would be column 4). The function has to be able though to be dynamic and sometimes will need to look in row 2 or row 5 depending on the criteria.
Thanks,
I'm trying to find a solution for an excel function in which I need to locate the column number based on a specific value match within an array. Normally I would use the Index Match function but the tricky thing is that within the array, the same value can appear in multiple rows and I have to find first identify the specific row number and then the specific column number based on two different identifying values. I do have a match function created to locate the specific row but wasn't sure how to then combine that in a function to then locate the column number of a specific value in that same row. In total I have 20 rows and 10 columns with similar values in each row but all of the values within a single row are unique.
As an example, In row 2 I have values of 0,2,1,00 and in row 3 I have values of 1,3,0,2. I have first created a Match function to identify that I need to look in row 3 but how can I come up with a function to say find the column number in row 3 that contains the value of 2 (which would be column 4). The function has to be able though to be dynamic and sometimes will need to look in row 2 or row 5 depending on the criteria.
Thanks,
