Hi! New to the forum, bear with me!
I'm having this situation where I want to do a MATCH() to fetch data for a specific year, but the target cells consists of year-spans. Say I want to look for the row of year 1957 within a table that look like this:
<tbody>
</tbody>
I can't split the year-spans because of external reference structure. Any tips on solving this issue is greatly appreciated!
I'm having this situation where I want to do a MATCH() to fetch data for a specific year, but the target cells consists of year-spans. Say I want to look for the row of year 1957 within a table that look like this:
-1948 | Data B1 | Data C1 |
1949-1954 | Data B2 | Data C2 |
1955-1959 | Data B3 | Data C3 |
1960- | Data B4 | Data C4 |
<tbody>
</tbody>
I can't split the year-spans because of external reference structure. Any tips on solving this issue is greatly appreciated!