Finding a match in different columns

Hi - I'd appreciate some help with a formula to do the following in Excel 2003...

If a number in cell M1 is also anywhere in column A (column A has unique numbers), then cell W1 (date) should equal the content of cell V (also date) in the row that that number appears in column A. If M1 is blank (or there is no match in column A), then W1 should equal V1.

In W1, I currently have...

Please Login or Register  to view this content.

but that's returning the value of V1 in W1

Any help would be much appreciated, thanks

Try:

=IF(ISNUMBER(MATCH(M1,A:A,0)),VLOOKUP(M1,A:V,22,FALSE),V1)

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

=if(m1="","",if(isnumber(match(m1,a:a,0)),vlookup(m1,a:v,22,false),v1))