Vlookup value, if false put value from a different cell into next cell

My table:

Serial Number, Moves, Install Date
12345, VLookup match (12345), 1/2/2016

If the VLookup matches I want to be able to change the date to a different one from another sheet. So far I only got the VLookup straight:

=IFERROR(VLOOKUP(A2,Moves!A:A,1,FALSE),"-")

I am looking for something that goes: If Serial Number is found in Moves Column put H2 from worksheet 2 into column Install Date in Sheet 1.

Does this make sense? Eternally grateful for any advise.

it appears your lookup table is on a different sheet - "Moves" from where this formula resides?

try this

=IF(ISERROR(VLOOKUP(A2,Moves!A:A,1,FALSE)=TRUE),"-",Sheet2!H2)

Thanks! So far so good:

=IF(ISERROR(VLOOKUP(A2,Moves!A:A,1,FALSE)=TRUE),"-", But then it has to look up A2 again and put N2 from Moves Sheet into Sheet1 C2.

I don't think another VLookup will do the trick as it replaces value next to cell that is being calculated. That's where I am stuck at. Capture.JPG

Not sure if you can see the screen shot but if a value comes up in B2 it needs to change the date in C2 from the other sheet. Do I make sense?

Sorry, I don't understand. You are not giving enough detail.
Is column C the install date?
What happened to sheet 2 H2? Are H2 and N2 always the absolute address of values or do they change based on where you are in the table?

You are too kind. Thanks for trying. I made a mock up, does this help?

Sorry, but your narration and comments on the mockup are too generic. For instance, what is "the last entry on sheet2"? To me, that is cell N5461. But you may mean the last time the serial number is found or the last entry in column A or the last entry on that row. And you have not supplied your Master Asset List, so based on sheet 2, I would expect the value of cell C2 to be 1/14/2016 from sheet 2 cell N3022.

I think you need a Vlookup that returns a value from sheet 2 column N if found, and from sheet 1 column A if not. If not that, I really don't understand. Sorry.