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