Robandemmy
Board Regular
- Joined
- Jul 16, 2018
- Messages
- 65
I have a table somewhat like:
Red 20
Red 30
Black 30
Black 20
Red 25
Red 15
Black 40
Closest to: 23
I want to write a formula that will return the value in column B that closest to 23 when column A equals Red. In this case 25.
Red 20
Red 30
Black 30
Black 20
Red 25
Red 15
Black 40
Closest to: 23
I want to write a formula that will return the value in column B that closest to 23 when column A equals Red. In this case 25.