Index using text field as reference for defined range

English
, , ,
#1

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?

#2

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.