Hi there,
VLOOKUP is the master of all functions in Excel. This is what every Excel Lover say about this function. VLOOKUP has gained a huge popularity because when some one says that he knows VLOOKUP that means that person knows Excel application. I think you understood the brand it has been gained from the public, right? Some thing equal to brand like TATA. I agree to this point, Do you?
As we all know how to extract the first instance using VLOOKUP, here is how we extract the second instance using vlookup function. The logic is very simple. Let me reveal before proceeding - just use a helper column by writing this function in it.
...
=C6&COUNTIF(C6:C14,C6)
Download working file .xlsx from here.
EXPLANATION:
Here we have a rawdata:
Note: If you find DOB is irrelavant to this example you can change the DOB to general format (select the DOB column and apply CTRL + SHIFT + ' [accent mark] ) and consider those values as Sales Report.
To extract the date of birth for this data it is difficult to extract without using helper column. right?
Let's say column A is the helper column and column B and column C will hold Name & DOB. After using helper column here is how it looks. Before showing how it is, it is important to know which formula is used to get that output.
=C6&COUNTIF(C6:C14,C6)
Don't you think, now it is possible to extract any instance we require using VLOOKUP. Yes it is. We can do it.
Just use this VLOOKUP formula to extract the data.
=VLOOKUP(B6,$B$6:$D$14,3,0)
That's it. Magic works.
DO YOU USE VLOOKUP?
Do you VLOOKUP for any other purpose? Please use this space to share your experience here using our comments section. If you like this post, share it with your social networking contacts and email contacts and be a first among your friends who share valuable information.
If you want to support me REGISTER here for free. Its absolutely free for you. Hurry up.
SOME IMPORTANT LINKS:
Thanks,
Recent comments