The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Vlookup & Columns vs. Index & Match

Back to all questions

Vlookup & Columns vs. Index & Match

3 months ago
Vote Up Vote Down
0
Votes
1
Answer

When filling out a table, why would someone prefer to use the Vlookup & Columns function over the Index & Match function? 

1 Answer

365 Team 3 months ago
Vote Up Vote Down
0
Votes

Hi Surya!
Thanks for reaching out.
The VLOOKUP function has certain limitations, but if a static column reference would do the job, if your dataset isn’t large, and your criteria won’t exceed 255 characters, you can use VLOOKUP instead of INDEX/MATCH.
VLOOKUP & COLUMNS is a combination that is applied in practice a lot so we wanted to make sure you can use it independently. Hence, we’ve included it in the syllabus.
Hope this helps.
Best,
Martin

You must to answer this question.