I'm using Excel 2007.
Thanks for your tips. i notice there is one variable I forgot to mention.
G10 (my lookup) can be a value in either column A or B.
If it is a value in column B, I want to return C.
If it is a value in column A, I want to return Column B, unless Column B is empty, then I want to return Column C.