I am trying to return the Column header based on a variable being closest in value to values in an area table.
That may sound confusing so here is a little data to show you what is being asked for
I have the following variables
Country = Germany
SKU = 1235
Requested price = 36,290
The expected retuned value is: TP2
I attempted to work with this formula but failed miserably: {=INDEX(A3:A5,MATCH(MIN(ABS(C2:E6-Requested Price)),ABS(C2:E6-Requested Price),0))}
I obviously need to include Columns A&B (Country & SKU) somewhere in the formula
That may sound confusing so here is a little data to show you what is being asked for
I have the following variables
Country = Germany
SKU = 1235
Requested price = 36,290
The expected retuned value is: TP2
I attempted to work with this formula but failed miserably: {=INDEX(A3:A5,MATCH(MIN(ABS(C2:E6-Requested Price)),ABS(C2:E6-Requested Price),0))}
I obviously need to include Columns A&B (Country & SKU) somewhere in the formula
Country | SKU | RRP | TP1 | TP2 |
UK | 1234 | 65,198 | 45,632 | 27,000 |
UK | 1235 | 65,198 | 45,632 | 27,000 |
France | 1234 | 54,301 | 38,011 | 27,000 |
Germany | 1234 | 54,173 | 24,000 | 19,800 |
Germany | 1235 | 54,173 | 24,000 | 19,800 |