I’m trying to get data from defined ranges using a dropdown list.

A1=Product,Price,Time

Using this formula, it will only display the “reference” Product, Price or Time

=INDEX(A1,VLOOKUP(A2,DataProd.AI1:AJ76,2),VLOOKUP(A5,DataProd.AI1:AJ76,2))

If i use the above formula with a sorted list, i get a 502

For instance, if the formula would be =INDEX(A1,5,7) it would display the “reference”

If i enter this formula manually, it gives me the error 502.

Filling in the reference manually does give me the right result. How can i make this work?