Turns out my job is not that kind of spreadsheet and I don't remember it from spreadsheet class in college. They were literally just talking to the wrong person.

I had to use vlookup yesterday and thought of this post again