Query in ms excel 2007

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: 203 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
07 October 2026
Senior Account Manager

Amplio Invest

Mumbai

M.Com

View Details
Company
12 October 2026
AUDIT , ACCOUNTS AND TAXATION

KDSS

New Delhi

B.Com

View Details
Company
13 October 2026
Accountant

Zerdi & Co. Chartered Accountants

Pune

B.Com

View Details
Company
08 October 2026
SALES TELECALLER

HIRE NOVA

Lucknow

Graduate (Any)

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details