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
- CLOSING STOCK QUERY
- Exiting partner in partnership firm in gst portal
- TDS on rent received on hardship compensation being rent on redevelopment of building
- Consequences of Non-Deduction of TDS under Income Tax???????????????
- Missed TDS
- IT returns for fresh job holders
- F&O reporting in ITR
- CASH GIFT FROM BLOOD RELATIVE
- TDS offline utility
- Due Date Clarity
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
- TDS on property - Form 141 query
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
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
