vipaman
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
With conditional formatting hiding not used values.
Hiding means setting font and cell colour the same as the general cell colour.
vipaman-book6.xlsm
Hiding means setting font and cell colour the same as the general cell colour.
vipaman-book6.xlsm
ASKER
Thank you once again. I was splitting out the Type etc into fields to apply an index and match function. Your way is slicker.
ASKER