I need a formula to display a value from a data table based on two entered variables which represent a column and a row in the table. I'm trying to go about this with a nested VLOOKUP and HLOOKUP, but I don't know how to account for the column index. This is supposed to be a set integer value, but my needs call for the column index in the VLOOKUP to be based on the column found by HLOOKUP and vice versa. How can I accomplish this?
Thanks for your help!
Thanks for your help!