I need formula of vlookup for multiple workbooks

436 views 3 replies
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...

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details
Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details