Quick Reference Card Vlookup. However we can still use VLOOKUP in this case to match on the last name. You can resolve the issue by anchoring the lookup reference with the operator like this.
Quick and Easy Tips. To use approximate-match VLOOKUP you must sort your data by the first column the lookup column then specify TRUE for the 4th argument. Oct 27 2014 - This Pin was discovered by Vicki Reece.
It could start in column A or it could start in column K.
Feel free to print a copy of the card or save it somewhere on your computer to refer to later. Feel free to print a copy of the card or save it somewhere on your computer to refer to later. You can use a reference to a range or a range name. To use wildcards with VLOOKUP you must specify exact match mode by providing FALSE or 0 for the last argument range_lookup.