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.