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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.