Like this? Taking an input of "alpha" and "phi" and backing out how big your tw needs to be?
Input:
E1 = alpha
E2 = phi
Output:
E3 = tw =
Those dupliated MATCHes in the middle feed the column number to the INDIRECT function, which uses R1C1 notation to pick the right column in the Vn table to MATCH some input phi against and deliver how many rows down the table it is; the INDEX number goes down the same number of rows right there in the tw column.
Notes:
1) Because the alpha is an exact match, if it's not something exactly on the spectrum (example: 30.15), it will throw an error.
2) By comparison, the phi is looking for the "greatest value equal to or less than" the input and returning the matching row, so if the data isn't in ascending order (like it goes over a hump) then it can ignore everything after the hump.
If you want to go the next size up, just slap a "1+" right in front of the very first MATCH word. (for example, if you put in phi = 440 and alpha = 30.5, the formula will return 0.625; that 1+ will bump it down a row).
Bookmarks