|If I understand your post correctly, I think this is what you are looking for.|
With a table that looks like this in A1:D4, the formula shown below will use the values in E1 and F1 to find the intersection of those values and, in this case, return 2c
A B C D E F
1 1 2 3 2 c
2 a 1a 2a 3a
3 b 1b 2b 3b
4 c 1c 2c 3c
The MATCH functions return the row_num and column_num arguments for the INDEX function.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.