If, Index vlookup help

[glitz12]

Kindly help me to solve this excel formula.


All i need to do is to type Emp. ID.

Once i type Emp. ID, i require the following information to be shown in the boxes highlighted.


Say for e.g. if i enter Emp. ID - it should extend Gender, Relation, 1st, 2nd and Family name, birth date, age, med pin no. and so on.


I have used IF,INDEX & VLOOKUP, but i could hardly find out only for 1st column.


Hope to get in touch with excel experts with this forum and trying to solve the problem.


http://www.ozgrid.com/forum/attachment.php?attachmentid=49928&d=1354369230

 

[bobhc]

Good day glitz12

Welcome to Chandoo


You may find the single vlookup on the attached file of help.


https://dl.dropbox.com/u/75495784/Correct_Formula-IfError_with_Vlookup.xlsx

 

[glitz12]

thanks bobs.


Happy to meet experts in this forum.... hope to go a long way.


Let me ask you - how do i get the right gender, when input the badge no.


The IFERROR formula provided in the sheet doesn't recognize the gender and gives no relevant answer.


would request your help in sorting out this.

 

[NARAYANK991]

Hi ,


Can you check out your file here ?


http://speedy.sh/K3Kfw/IF-INDEX-VLOOKUP-HELP.xlsx


Narayan

 

[glitz12]

thank you both of you....


file works well.