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 :
- Practical queries on buy back of shares
- Any faculty recommendations for latest batch recor
- FAI & FAST-DS 2026 query
- Is GST registration mandatory in this case
- Buying a residential flat in Goa: should my wife b
- Income tax filling
- Applicability of RCM in the case of import of serv
- Confusion in gst registration for service category
- Itc claimed from return defaulters
- Gst input credit
Related Topics :
CAclubindia
