Drawback of VLOOKUP, alternative to solve this.
AnswerBot
1y
VLOOKUP has limitations in handling large datasets and requires exact match. INDEX-MATCH is an alternative.
VLOOKUP can only search for values in the leftmost column of the table array
VLOOKUP requires ...read more
Help your peers!
Add answer anonymously...
Top Accenture Consultant interview questions & answers
Popular interview questions of Consultant
Top HR questions asked in Accenture Consultant
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app