The vlookup function already does this.

see Excel help. You can use it in VBA as well.

--
Regards,
Tom Ogilvy

"Tony" wrote in message
om...
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.