Sarah from the cattle farm in the UK writes in again with an insanely difficult question. Do a VLOOKUP, but find the last previous entry that matches the veh...

Keywords for this video: Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, VLOOKUP

This video is current as of August 9, 2009

For more resources for Microsoft Excel:

• Excel VBA Book
• Ctrl+Shift+Enter Array Formulas
• Learn Excel from MrExcel