Hi...him new over here.
I'm trying to build a function that finds a value and return the next cell value.

A B C
1 RED 50
2 BLUE 101
3 BLACK 230
4 GRAY 25
5

For example...if a run the function for "black" then it should return 230.
If i used it for blue then it should return 101.

Any help or ideas are welcome.Thanks in advance.