Hi Team
wondering if you can help. I have 2 worksheets:
Worksheet 1: Lookup table that has 2 columns that provides a water level and a volume - derived from a model
<tbody>
</tbody>
Worksheet 2: Data entry sheet where a level is entered and then the second column should input the closest volume (or better yet, proportionate volume if there is not an exact match) based on the lookup sheet:
<tbody>
</tbody>
I have tried a combination of Match and Vlookup but have not had any success.
Thank you
John
wondering if you can help. I have 2 worksheets:
Worksheet 1: Lookup table that has 2 columns that provides a water level and a volume - derived from a model
Level | Volume |
1330 | 14292.8 |
1329.9 | 14277.4 |
1329.8 | 14262.0 |
1329.7 | 14246.4 |
1329.6 | 14230.7 |
1329.5 | 14214.7 |
1329.4 | 14198.4 |
<tbody>
</tbody>
Worksheet 2: Data entry sheet where a level is entered and then the second column should input the closest volume (or better yet, proportionate volume if there is not an exact match) based on the lookup sheet:
Level | Volume |
1329.71 | ? |
<tbody>
</tbody>
I have tried a combination of Match and Vlookup but have not had any success.
Thank you
John