First match two cells then find closes value to another value corresponding to another cell

[Molke]

Hi Great people of excel users

I have I problem I need some help solving, I have looked at some different ways to solve it, can't make it work.

I want to be able to change the value in "kategory" to either a,b or c, and then the value I input underneath correspond to the closet value in that column's results.

so here I have a 1500, which will give me 1520
were if I have b 1640, it will give me 1600 since it closer to 1600 than 1700 in the b values

Hope it makes sence, and you guys can help me

 

[jasonb75]

Here's one way that works,

Codename.xlsm
	A	B
1
2	a	1420
3	a	1520
4	a	1620
5	b	1500
6	b	1600
7	b	1700
8	c	1410
9	c	1510
10	c	1610
11
12	a	b
13	1500	1640
14	1520	1600
Sheet2

Cell Formulas
Range	Formula
A14:B14	A14	=AGGREGATE(14,6,$B$2:$B$10/($A$2:$A$10=A12)/(ABS($B$2:$B$10-A13)=AGGREGATE(15,6,ABS($B$2:$B$10-A13)/($A$2:$A$10=A12),1)),1)

 

[Molke]

Thank you so much, it works exactly as intended
Have a Good Weekend and Holidays