fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 437
- Office Version
- 365
- Platform
- Windows
I have a formula that refers to a named range to return total, but the name range after"_" depends cell value. How can combine a text + the cell value that would call the name range. The formula I used below is giving me #value ! error.
=SUMPRODUCT((Company=c2)*(CC=D2)*("Amount_"&E2))
Name Range: Amount_PROC
E2 has a value of PROC
=SUMPRODUCT((Company=c2)*(CC=D2)*("Amount_"&E2))
Name Range: Amount_PROC
E2 has a value of PROC