Hi guys,
I am trying to create a sort of flow chart using dependent dropdown lists.
I have managed to get 3 dropdowns working, but I am struggling with the 4th dropdown.
In this example:
A2=ProductList
B2=INDIRECT(VLOOKUP(A2,ProductLookup,2,0)&"List")
C2=INDIRECT(VLOOKUP(B2,INDIRECT(VLOOKUP(A2,ProductLookup,2,0)&"Lookup"),2,0)&"List")
I am trying to now add a fourth column now to determine the Region of the where the fruit came from e.g. Mac Apple from Portugal, however I am receiving an error when trying the below formula.
D2=INDIRECT(VLOOKUP(C2,INDIRECT(VLOOKUP(B2,INDIRECT(VLOOKUP(A2,ProductLookup,2,0)&"Lookup),2,0),2,0)&"Lookup")

Portugal and Italy have been set up as a lookup table with Maclist - called MacLookup

I am unsure as to why I am receiving this error, and would appreciate any help I could get with it.
Thank you
I am trying to create a sort of flow chart using dependent dropdown lists.
I have managed to get 3 dropdowns working, but I am struggling with the 4th dropdown.
In this example:
A2=ProductList
B2=INDIRECT(VLOOKUP(A2,ProductLookup,2,0)&"List")
C2=INDIRECT(VLOOKUP(B2,INDIRECT(VLOOKUP(A2,ProductLookup,2,0)&"Lookup"),2,0)&"List")
I am trying to now add a fourth column now to determine the Region of the where the fruit came from e.g. Mac Apple from Portugal, however I am receiving an error when trying the below formula.
D2=INDIRECT(VLOOKUP(C2,INDIRECT(VLOOKUP(B2,INDIRECT(VLOOKUP(A2,ProductLookup,2,0)&"Lookup),2,0),2,0)&"Lookup")
Portugal and Italy have been set up as a lookup table with Maclist - called MacLookup
I am unsure as to why I am receiving this error, and would appreciate any help I could get with it.
Thank you