Excel Magic Trick
Files:
https://people.highline.edu/mgirvin/Y...
See how to use an Approximate Match VLOOKUP function and lock the cell references that you can copy it down an entire column. See Absolute Cell References and Relative Cell References.
