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 :
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
- Which Aviation Services Can Air Ticketing Professi
- Section 87A
- GST on Transport
- Which software to buy
- Property Selling and buying
- Office Management System
- Can I pursue articleship alongside a regular full-
Related Topics :
CAclubindia
