God bless whoever can help me with this. Bear with me, things have been altered to protect some information so hopefully this makes sense.
My goal: create a index and match function in X4 that will retrieve a value from 'RLB Index'.
The issue: The data on 'RLB Index' is sorted into three locations: 1,2 and 11. The lookup value for the location is D3, and the validated options are locations 1-10. What I want to do, is force the index/ match function to use location 11 if locations 8-10 are selected in D3.
This is the equation I have so far that just uses D3 as-is.
{=INDEX('RLB Index'!$C$2:$E$53,MATCH('UC Worksheet'!F4&G4,'RLB Index'!$A$2:$A$53&'RLB Index'!$B$2:$B$53,0),MATCH('UC Worksheet'!$D$3,'RLB Index'!$C$1:$E$1,0))}
Huge thanks to anyone that can help.
Bookmarks