Need a function that finds a value in a table range and returns the cell number

T

Tony

HI, i need a function that finds a value in a table range and returns
the next cell value.
For example

Got this list
A B C
1 RED 120
2 BLUE 10
3 BLACK 230
4 PINK 330
5 WHITE 500
6


If want to find black...so the function should return 230. Thanks
 
Top