Use the Excel Data Model to avoid using VLOOKUPs when analyzing data