I wrote a correct VLookUp function, and it is calculating correctly. When I
drag the function down the column to populate the rest of the neccessary
fields, it populated the "looked up" answer for the first cell instead of for
the appropriate cell. If I click in each cell individually (as if to edit the
text) and then click away, the correct answer appears. How do I make this
happen for all the cells without clicking each one seperatly (there are 1000
rows) ...