Forum Discussion
Look up values in 3 successive columns and return the value in final row from 4th column.
That could be
=LOOKUP(PI(),1/((A1:A200=14)*(B1:B200="RB1")*(C1:C200=1)),D1:D200)
The result returned is #N/A.
It returns #N/A if you have no such combination. For such cases you may wrap formula like
=IFNA(LOOKUP(PI(),1/((A1:A200=14)*(B1:B200="RB1")*(C1:C200=1)),D1:D200),"no such")
In general it works, please check attached file.
Possible reasons why doesn't match - you compare text "1" and number 1; etc.
Still having trouble with this process.
Column A is values
Column B is text
Column C is values
Colum D is value
I need to find a value in column A (there will be from 5 to 20), within these rows find in column B a certain label (may be 1 or 3 choices), within these 3 choices in column C a value and return the value listed in that row from column D.
Your attached file is close to what I have but the formula still doesn't work.
Any other suggestions?
SergeiBaklan Pi rocks!
Detlef_Lewin , I was going to use 2 as usual, but recall your discussion here long ago about the PI(). Just more sexy...
