You're getting NA for your VLOOKUP . We're looking in a cell for our search key . Here we have a score A. We're just trying to get an emoji A8 to C12. But as we copy and paste it, we get NA. Why? The answer is because we have not fortified our range . We're going to move it down one each time we copy paste. A9 to C13. One more down. It's A10 to A1 to C15. So, how do we fix this NA problem? Go into our original top one where we have the correct range here. We're going to add a dollar sign in front of the A, in front of the eight, in front of the C, and in front of the 12. And we're going to say, don't move this. So now

when we copy and paste it's correct.