Excel Forum



Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)


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.





Got a Question? Ask it Here in the Forum.