Thanks in advance for any suggestions. I am trying to do a 2 way lookup using index match. The first part of the match will be to the column A2:A10 where the values are arranged in ranges. A2 would be 1-5, A3 would be 6-10, A4 would be 11-15 ect.
So I can't seem to make it work but I think it should look something like =index(B2:E10,Match(J20,A2:A10,[WHAT SHOULD I PUT HERE?]),MATCH(J21,B1:H1,0))
So I can't seem to make it work but I think it should look something like =index(B2:E10,Match(J20,A2:A10,[WHAT SHOULD I PUT HERE?]),MATCH(J21,B1:H1,0))