Unfortunately i cannot do that. I have hundreds of different old paycodes to convert, hence the lookup. The 2nd and 3rd letters change and are not just A, P or R. Its only the 3rd letters that reference a "P" i need to convert.
So what i am reying to say is;
If the ref cell contains a P in the 3rd position vse the lookup. If not, just stick with the existing reference cell.
So i added another code for reference sake.
Thanks,
Jon
|