Forum Discussion
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 ...
Yes, that's just the basic formula. After that you may modify it depends on how your real data is structured and how you'd like to present the result. I'm not sure what do you mean under the template. As an example you may select your values to lookup from drop-down lists as
formula here will be modified as
=IFNA(LOOKUP(PI(),1/(A5:A453=$K$5)/(B5:B453=" "&$L$5)/(C5:C453=$M$5),D5:D453),"no such")
data for drop-down list could be added manually or generated automatically from you source data. In attached files is quite simple illustration of such approach.
But basis formula is the same.
Thanks for the assist. I have it working. Great suggestions!