On one sheet (Sheet1) I have a column (SH1 C1) of 2000+ item numbers
and the coresponding inventory numbers in an adjacent colum (SH1 C2). 
On another sheet (Sheet2) I have a list of a few hundred products that
I carry and one column has their item numbers in them (SH2 C1) along
with a corresponding column for inventory (SH2 C2).  I want a macro
that can find the corresponding job number in the large inventory
sheet (SH1 C1) and place the correct inventory number (SH1 C2) into
the matching column (SH2 C2) on my sheet.  I want it to loop through
so it will find the right inventory number for the right item number
for every row that I have on my sheet(SH2).
I feel like it's a simple VBA code but can't get it to work right
Can you help me?

Why not use the vlookup worksheet function?