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: 191 times
Menu
Query in ms excel 2007
Attached File : 484808 812272 vlookup.xlsx downloaded: 191 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
Recent Topic
- AIS UTILITY
- NPS Premature withdrawl -Tier 1 Account
- Provident fund taxation
- ITR3 AY 26-27 Error in filling status
- Queries on TDS as per IT
- Capital Gains set off on Sale of Land if held for
- ITR Form for income from freelance consultancy
- Gst rate for HSN code 28530010
- Health Insurance
- India GST Mobile App
Related Topics
CAclubindia
