I am trying to look up a value and return the value in the next column, however if the lookup value does not appear, then lookup the value in a seperate column. I have excel 2003.