Vlookup not working - table array turning red with $$

[Jannatre]

I could use some help! When I try to do a v-look up on a spreadsheet I've used for 6 months the table array doesn't work.

On the spreadsheet I'm pulling from when I go to highlight the columns it turns red and puts $ signs. Then it crashes my spreadsheets.

I can't post a screenshot here but basically when I pull down the array, it highlights them in red and here is what shows up in the formula field: =VLOOKUP(B878,$A$5:$B$22) (the last part is in red)

While I know how to do v-look ups I'm not an IT person and have no clue how to fix this. Please help!!

 

[GJSBED]

You have a vital part of your vlookup missing....

=VLOOKUP(B878,$A$5:$B$22,FALSE)

 

[Jannatre]

Thanks for responding! There is no "FALSE" because I purposely didn't finish the formula. I was just showing how the $ signs pop up and that's when the spreadsheet columns turn red (adding those $ signs). That's what I'm trying to fix.