The error means that the VLOOKUP did not find a match. It could be a few reasons. Based on your formula, we'll start with this...

Okay, you want to lock your range (A1:C2858) in place using $. When you copy formula's from place to place, the cell references change. Often this is a good thing, like if I have in C1 = A1 + B1 and I copy that to C2, I'd like the formula to change to =A2+B2. Sometimes you don't want the reference to move and then you use anchors ($) to lock them in place. So try

= VLOOKUP(G1, $A$1:$C$2858,2,FALSE)