Inventory compare and copy Script

[fritzfreund]

Situation: I need a script that will search through two worksheets and
find serial numbers that are the same. Than I need to copy the asset
ID from the first sheet into the correct one on the second sheet.
Example
Sheet1
AssetID Desc s/n
123 stuff 1
124 junk 2
125 tools 3

Sheet2

AssetID Desc s/n
thing 4
junk 2
tools 3
stuff 1

I need them both to have the asset ID numbers that are in Sheet1. I
was trying to do an IF statement but I don't know enough about
programming in excel (or in general) to set it up correctly. Can
anyone please help me?

 

[Guest]

Sounds like you could do this with a vlookup, check here or in Excel help for
details, kind of complex to explain from scratch

 

[fritzfreund]

Sounds like you could do this with a vlookup, check here or in Excel help for
details, kind of complex to explain from scratch

I tried that, it would work on a small scale but not a large one. Here
is what my vlookup looked like.
=VLOOKUP(H4,AllAssets!$A$3:$K$753,1,FALSE)

But that doesn't work. I am not sure if it is because of the number of
cells is must search or because I am trying to return from column 1.