Excel formula
This query is : Resolved
11 October 2010
please inform me the steps of vlook up formula & logical formula.
mail id -- ghosh.2009@yahoo.co.in
mail id -- ghosh.2009@yahoo.co.in
12 October 2010
EX
Table A
Cl 1 CL 2
Name Value
SK 500
BK 300
Table B
CL 1 CL 2
Name EXp
SK 500
BK 100
Formula , if you want to get for table A , exp for all the name
=vlookup(table A col1,Table B cl1:cl2,2,0)
Table A
Cl 1 CL 2
Name Value
SK 500
BK 300
Table B
CL 1 CL 2
Name EXp
SK 500
BK 100
Formula , if you want to get for table A , exp for all the name
=vlookup(table A col1,Table B cl1:cl2,2,0)
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Difference between Date of Payment and Date of Deduction?
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Unregistered suppliers utility
- ITDS U/S.194T of Firm
- EXPORT COMMERCIAL INVOICE HSN CODE
- Need Professional Opinion - AY 2012-13 Old Demand & AY 2026-27 Refund Adjustment
- Cash balance limit and property purchases limit
- ADDITION OF CHALLAN IN TDS RETURN FORM 140
- Non-Compliance documents have not been submitted by the contractors debited
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
