Quote Originally Posted by nflsales View Post
probably the below you are looking for

=vlookup(A2,tab 2!$H$5:$h$138816,2,False)
try this and copy towards down

Still getting "n a" error. MS help states "enter a cell reference instead of a range reference". I had the cell reference in place earlier and got the same message.