ALEDG1987
11-18-2022, 07:49 AM
Hi all,
I'm looking for a formula which can lookup the value in column A, then lookup the value in column B to determine the row which to select.
Then based on the selected row perform linear interpolation of a value in the columns shown under 'C'.
In this example the row values are not changing but there are other tables in which the values are different.
I'm looking for a formula which can lookup the value in column A, then lookup the value in column B to determine the row which to select.
Then based on the selected row perform linear interpolation of a value in the columns shown under 'C'.
In this example the row values are not changing but there are other tables in which the values are different.