I need formula of vlookup for multiple workbooks

451 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
16 July 2026
Manager - Finance & Accounts

Aliens Group

Hyderabad

CA Final

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

G A R U D & Associates

New Delhi

CA Inter

View Details
Company
06 July 2026
Senior Accountant

Arvindkumar Maniar & Co.

Rajkot

CA

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
22 July 2026
Senior Chartered Accountant

SKSS

Patna

CA

View Details
Company
ARTICLESHIP 14 July 2026
Article Assistants

R Shyam and Associates

New Delhi

CA Final

View Details
Company
23 July 2026
Senior Accountant

Felicity Adobe LLP

Bengaluru

CA Inter

View Details