Unsure on how to approach data

Hi, the attached file in excel contains some calculations that result in images changing and then as a result further data is inputted resulting in some output.
Cell U16 = Type A-E
Cell U18 = Upwind or downwind
Cells V20 - W27 contains a series of text/calculations which display Twind values for Types A-E.
Cell Z23 needs to contain the output of one value from W20-W27 based on U16 and U18
I could simply enter value Z23 by reviewing W20-W27, but thought it would be nice to automate.
I was looking at match and array, but struggling to understand how to deal with the wildcard search on cells V20-v27; if that makes sense.
Thanks in advance
book6.xlsm
vipamanAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
You can use this formula
=INDEX(W20:W27,MATCH(1,INDEX((LEFT(V20:V27,6)=U16)*(RIGHT(V20:V27,LEN(V20:V27)-14)=U18),,),0),1)
vipaman-book6.xlsm
0
 
vipamanAuthor Commented:
Is one thought to hide the cells that don't meet the criteria set by U16 & U18 and then Z23 looks at cells W20-W27 and returns any value it sees? I am using cell Z23 to feedback to another worksheet, hence the static nature of it.
0
 
Ejgil HedegaardCommented:
With conditional formatting hiding not used values.
Hiding means setting font and cell colour the same as the general cell colour.
vipaman-book6.xlsm
0
 
vipamanAuthor Commented:
Thank you once again. I was splitting out the Type etc into fields to apply an index and match function. Your way is slicker.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.