Vlookup SyntaxAssistance

[robertguy]

Hi,

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

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

Please Login or Register  to view this content.

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

[Punnam]

Hi

Provide a sample sheet

Punnam

[egemencoskun]

"for records it does not find to 'MOVE" for records the Vlookup formula finds.."

Sorry Robert I am not sure what you mean by this? If you can give a bit more details then we might be able to help :-)

[robertguy]

Hi,

I've attached a sample workbook which has two worksheets i.e.’ Open Request’ and ‘Requests in Delivery’ and I've added a helper column on the 'Open Request' called 'Lookup' in column 'Y' which has the lookup formula.

What I'm trying to do is for the vlookup formula to check if any 'Request Numbers' in column 'A' on the 'Open Request' tab DO NOT match the 'Request Numbers' in column 'A' on the Requests in Delivery' tab and enter the text 'MOVE" instead of “** - New This Period - **" if any records are found in order for me to then filter on any records flagged as ‘MOVE’ in order for me to manually move these records from the ’Open Request’ tab to the ‘Requests in Delivery’ tab

Thanks again Rob

[egemencoskun]

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

If you just want to change the text if no match found then this is it.

[Punnam]

Hi,


The requirement is not clear at i have made changes .check it once let us know .


Regards,
Punnam

Sample.xlsx