Hi there,
I have an extensive list of data and I need to return certain results in the 'ACTION' column B depending on the 'OUTPUT' in column C. I've attached a sample. The resultant value in column B needs to look at the first number only in column C and then look at column E and return the corresponding 'ACTION REF' as listed in the column F.
Any assistance would be gratefully received.
Regards
Ben
Bookmarks