Query in ms excel 2007

others 659 views 3 replies

hii experts,

I have query in MS Excel.

Please find the attached file below and solve my query.

Thanks and Regards,

Vishal Thakur


Attached File : 484808 812272 vlookup.xlsx downloaded: 164 times
Replies (3)

whenever you apply vlookup it always catch the 1st vlookup value in your case its is chirag

Thats the reason you are getting this problem

Whether there is any other formula which catch the values seperatly??

=VLOOKUP(A7,Sheet2!$A$5:$B$7,2,0)

Pls paste this formula and specify exact location for 2nd name.

 

Rahul Sharma


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register