Here a sample of the data I'm working with, in columns A-C (data is much more extensive obviously:
1000 61.2 306.5
1000 70.5 330.2
2000 72.3 312.7
2000 92.8 370.6
3000 62.5 314.9
3000 92.6 340.5

I want the user to be able to input two values which will be checked against columns A and B, and return the corresponding value in C. The lookup for the column A value should be exact, but the column B lookup should be the closest match. However, the closest match should be filtered by the lookup of column A first.

For example, lets say the user inputs 3000 and 94. The formula should filter all data by the 3000 input first, then find the closest match in column B for just that dataset, and return the corresponding value in column C (in the example, it should return 340.5).

I tried a combination of index-match, vlookup, and filtered arrays, but couldn't figure it out. The biggest problem I was having was figuring out how to have the formula filter first by column A, then find the closest match in column B for the filtered data.

Also, in the example I noted, if 3000 is changed to 2000, then the formula should return 370.6.

Thanks in advance for your help!