So I am attempting to find the C Value from comparing two criteria (Given P and L) from two separate tables (Table 1 and Table 2).
It needs to validate from both tables. I created the two below, but it is not working. Any advice to fix it or another alternative would be greatly appreciated!
Given P Value=GivenP
Given L Value=GivenL
Find/Display C Value=FindC
Table 2
Range of P Values in Table 2=T2PRange
Range of C Values in Table 2=T2CRange
Range of L Values in Table 2=T2LRange
Table 1
Range of P Values in Table 1=T1PRange
Range of C Values in Table 1=T1CRange
Beta=INDEX(T2CRange,MATCH(1,(GivenP=T2PRange)*(GivenL=T2LRange),0))
Beta=Should displays Value of C in Table 2
Delta=INDEX(T1CRange,SUMPRODUCT((T1CRange=Beta)*(T1PRange=GivenP)*ROW(T1CRange)),0)
Delta=Should display FindC
Bookmarks