gmbristow91
New Member
- Joined
- Feb 2, 2016
- Messages
- 41
Hi,
I have a formula that refers to a named range to return the value, but the value it returns depends on what is chosen from a dropdown list. The value from the dropdown list plus a text string would = the named range to reference. The formula I am currently using is throwing the #value ! error. This is what I have so far.
I have a formula that refers to a named range to return the value, but the value it returns depends on what is chosen from a dropdown list. The value from the dropdown list plus a text string would = the named range to reference. The formula I am currently using is throwing the #value ! error. This is what I have so far.
Code:
=INDEX(CONCATENATE(B33,"_Schemes"),MATCH($B$32,CONCATENATE(B33,"_Schemes2"),0)+ROWS(E28:E$28),COLUMNS($D28:E28))