banner_ad

Query in ms excel 2007

others 700 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: 181 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  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details