hi,
in column b i have a list of order numbers. in another tab i have a range called order numbers with a description in the colum next to them. in column A i want to return the description of the order number in column b. however, if the order number doesn't exist in the range i want to return a blank value or some text saying 'no work centre description'.
Any help is greatly appreciated.
david
Bookmarks