Thanks for replying! I think it makes sense. I should have looked at my example better. The table reference A1:B6 in my example is arbitrary. In my actual reference table, I have 12 columns, so my X1 cell value would be 1-12 depending on the 3 variables in A1, B1, C1.
So, my hope was that the Index value in the VLOOKUP formlula, could be based on the value represented in cell X1.
Bookmarks