Hi,

can anyone please assist me with the correct syntax for a Vlokkup formula

currently I have the following VLookup formula which works fine :-


IFERROR(VLOOKUP(A2,'Requests in Delivery'!A:A,1,0),"** - New This Period - **")


however , what I require is for the formula to be amended so instead of saying ** - New This Period - ** for records it does not find to 'MOVE" for records the Vlookup formula finds..

Any assistance would be greatly appreciated


Many thanks in advance


Regards


Rob