The tricky vlookup formulae

HI friends,

We are all ready know about the powerful vlookup formula in excel. I am do some test on this vlookup formula for make a master vlookup formula to lookup on the left most column from a master data sheet. I want to share the master formula with all of you.

Here is some limitation of the formula which are following:

1) In A1 cell of formula sheet put the value of A1 cell of data sheet
2) if you want to lookup on any other column then you must be change the table_array of the vlookup formula and freeze it for just one time
3)Must be put the same value in b1,c1,d1,......... which is same in the data sheet


The following vlookup formula specially describe for finding the column_index_number through the match formula


Formula Vlookup:
=VLOOKUP($A2,'Data Sheet'!$1:$65536,MATCH(C$1,'Data Sheet'!$1:$1,0),1)


here am also attached a file for showing you how you can used this formula.

if you want any clarification leave a comment me

Thank You:


Download: Click Here