Sorry guys, you are right, it was my misunderstanding. I hadn't used Excel functions in a while so I have been reading some guides and things and I totally misunderstood a pretty clear statement. It said that VLOOKUP "Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array." For some reason I just saw "first column" and had it in my head that it only searches for values in the first column of the entire spreadsheet. Thanks for setting me straight.