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
- GSTR-1A How to update Invoice
- Excess salary payment.
- Stamp Paper for partnership firm change new income tax 2025
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- TDS on Purchase of Immovable Property by NRI from NRI
- Capital gain from sale of house property
- INTEREST APPLICABLE ON ITC REVERSAL PORTION
- Value of property in capital gain
- When TDS on GST applied
- Before GSTAT- APL-02 Vs APL-04
- TDS APPLICABILITY......
- Copyright software
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
