Consulting

Results 1 to 1 of 1

Thread: Linear interpolation with lookup of two values

  1. #1

    Linear interpolation with lookup of two values

    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.
    Attached Images Attached Images

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •