Forum Discussion
BYahr1512
Feb 10, 2019Copper Contributor
Look up values in 3 successive columns and return the value in final row from 4th column.
I have data in columns that I need to look up a value in the first column, then the second, then the third and return the value found in the final row and a fourth column. Example: Within the rows ...
SergeiBaklan
Feb 10, 2019Diamond Contributor
That could be
=LOOKUP(PI(),1/((A1:A200=14)*(B1:B200="RB1")*(C1:C200=1)),D1:D200)
Detlef_Lewin
Feb 10, 2019Silver Contributor
SergeiBaklan Pi rocks!
- SergeiBaklanFeb 10, 2019Diamond Contributor
Detlef_Lewin , I was going to use 2 as usual, but recall your discussion here long ago about the PI(). Just more sexy...