Register now or log in to join your professional community.
first of all make database worksheet and select your data and make data table after give name your data table
than work with vlookup on next worksheet
when you put your data table name using vlookup it's work