Register now or log in to join your professional community.
Vlookup work on both type data
static data
dynamic data
you can use with with so many function
index+match not work like Vlookup
if you use Vlookup with data table it's better than index+match
Vlookup requires a static column reference while Index requires a dyanmic column reference. With Vlookup, we insert a static specifc number we want to a value returned from. With index function, we manually choose the column to pull off the value.
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.