Hi There!
Please see attached. I'm hoping to find some help in how to format the attached spreadsheet to achieve the desired results. I’m trying to populate cell C14 dependent on selections made in drop down menus located in C2:C5. I've inserted a table in the spreadsheet outlining the desired results (this should make more sense once the document is opened as well).
-KKP
if you are using 2010 version (don't have "textjoin"),
C14=INDEX(C17:C52,MIN(IF(($B$17:$B$49=C2)*(C17:C49<>"")*(B18:B50=C3)*(B19:B51=C4)*(B20:B52=C5),ROW(B17:B49),"/"))-16) control+shift+enter
Thanks for the reply! I also have access to Excel 2016 if that would be of better use.
Last edited by AliGW; 08-27-2019 at 03:40 AM. Reason: Please don't quote unnecessarily!
That's a VERY clunky data layout. Set up a simple table and use this:
=VLOOKUP(C2&C3&C4&C5,T:U,2,FALSE)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you Glenn! I agree. This works perfectly!
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks