Skip to main content

Posts

Showing posts with the label vlookup

Looking up for an example on VLOOKUP?

From all the questions I have been asked about and I have asked mostly are related to Excel Formulas If I filter even further I will find that I am looking for information on vlookup most of the times… Here is one attempt from my end to explain what vlookup is all about. What’s VLOOKUP? Ya ya apart from the obvious answer that its an excel formula, it’s a search function! It can find you matching information from a particular table of data – something similar to a hashtable or dictionary in data structures   You give it an identifier and it will find the corresponding value for it…   Can I get a VLOOKUP Example? Of course! That’s what this blog is about   Jokes apart, here is an example of VLOOKUP Problem Statement: Your boss asks you to find out the work experience in number of years of your team mates Data you have: Now you have to fill in this table to present it to your boss: Now you’ll get the data in columns H, I from C and D – isn’t it? that’s simple   You have