Forum Discussion
Look up values in 3 successive columns and return the value in final row from 4th column.
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?
Format doesn't matter, with the rest I don't catch what's wrong. Could you please provide small sample file or modify attached one to illustrate what doesn't work.
Not sure how to upload to this site. Hopefully, attached to this post is a sample with examples of what I have tried.