Your VLOOKUP formula is entered incorrectly.
put this in C2
=VLOOKUP(B2,Sheet1!$B$2:$BV$86,33,0)
normally you could just copy this formula down your column, but you have what appears to be rows in between where you do not use the vlookup. You can just copy and paste the above formula into each cell and then just change B2 to match the cell it needs to look for the lookup value.
Bookmarks