Excel Quaries
This query is : Resolved
05 February 2010
Columm A Column B
6,359.00 2,686.00
6,373.00 9,667.00
9,667.00 8,465.00
8,465.00 6,359.00
2,296.00 3,205.00
2,436.00 2,540.00
6,139.00 5,017.00
3,696.00 4,253.00
4,574.00 1,068.00
1,767.00 1,078.00
2,686.00 2,296.00
2,645.00
3,205.00
2,540.00
we want to reconcile each Amount in Column B with Column A
if same amount of Column A found in Column B result True other wise false
Which Formula We should Use …
6,359.00 2,686.00
6,373.00 9,667.00
9,667.00 8,465.00
8,465.00 6,359.00
2,296.00 3,205.00
2,436.00 2,540.00
6,139.00 5,017.00
3,696.00 4,253.00
4,574.00 1,068.00
1,767.00 1,078.00
2,686.00 2,296.00
2,645.00
3,205.00
2,540.00
we want to reconcile each Amount in Column B with Column A
if same amount of Column A found in Column B result True other wise false
Which Formula We should Use …
05 February 2010
Put values in col A and col B, paste this forumla in col C. You can change the selection range depending on the number of rows
=IF(VLOOKUP(B1,$A$1:$A$16,1,0)>0,TRUE, #N/A)
=IF(VLOOKUP(B1,$A$1:$A$16,1,0)>0,TRUE, #N/A)
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
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- TODAY INCOME TAX SITE IS NOT WORKING ANY OFFICIAL EXTENSION
- Sec 44ada applicable only or both
- IS AUDIT MANDATORY IF COMMISSION INCOME IS MORE THAN 50 LAKH
- RELATED TO TRIBUNAL APPEAL
- Portuguese Civil Code IT Return
- LIC maturity claim whether taxable
- HOUSING LOAN ISSUE
- 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
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
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
