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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- RCM INVOICING FROM NOV-2024
- Confusion around Form 26QB fields
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- TDS under section and rate of TDS
- GST input on scooter purchased
- TDS under section 194Q and TCS under section 206C
- GST input on car insurance and repairs
- GST input on Diwali gift to employee
- GST input on Mobile Handset
- Material and freight in same invoice
- TDS under section 194J inclusive of reimbursement of expenses
- TDS on Material and Labour in same invoice
- Should I be worried about and rectify reporting Jan,Feb ,March 2024 foreign salary in schedule FA?
Trending Online Classes
CAclubindia
