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 …
CA Shishir
(Expert)
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
- Accounting treatment of AMC alongwith the purchase of Laptop
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Transfer of Physical Stock Between Two Proprietorship Concerns
- Taxation of crypto futures in India Fy 2026- 2027
- EPF ECR NEW RULES Sep 17th 2026
- Issuing of delivery challan by seller of goods
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
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
