Menu
I need formula of vlookup for multiple workbooks
Hi I have a data in one of the excel file which a need to compare with multiple workbooks. The problem is that all the file are not having same number of col. and heading. I would like to know what will be simplest way or the formula for vlookup
Replies (3)
You can try index and match functions together =index(column I want a return value from, Match(my look up value , column I want to look up against, Enter "0"))
How can I use this formula for multiple workbooks?
why dont you submit test data...
Recent Topics :
- TAX TREATMENT AND ACCOUNTING ENTRIEOF PERQUISITES
- Gifting money to my father-in-law (my husband's da
- GSTR-1 JSON from marketplace exports (Myntra / Ama
- Question on buy back of shares
- Saving corporate tax completely on profit from rea
- Hi experts need some helps
- A query regarding GST and Place of Supply:
- ADT-3 not filed by previous Auditor
- Revising salary on 24Q Q4 FY 25-26
- LTCG: Home Loan Principal Repayment?
Related Topics :
CAclubindia
