Vlookup with Match formula
File details
File description
Vlookup looks for data matching date in column B( Main sheet) with date row in column A(fxdata sheet) where as Match formula exactyly pix up currency row in "fxdata" matching currency in cloumn D in sheet "Main" #xls
Comments
Recent Files in Technology & Tools
View more →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
Popular Files
- CA Intermediate Taxation Question Paper New Course September 2026
- Sources of Variation in India's Foreign Exchange Reserves during April-June 2026
- Developments in India's Balance of Payments for the m/o July 2026
- RBI Data on Forex Inflows
- ICAI Members' Journal - September 2026
- ICAI Students' Journal - September 2026
- Withholding Tax Rates as per IT Act 2025
- FAQs on Agricultural Income (Section 2(5) and Rule 270) as per IT Act 2025
- FAQs on Tax Audit as per IT Act 2025
- FAQs on TAN as per IT Act 2025
CAclubindia
