banner_ad

I need formula of vlookup for multiple workbooks

Others 430 views 3 replies
User Avatar

Accountant
23 Points Posted on 12 April 2017
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
0 Reply Share Follow
On 12 April 2017 at 18:15 Report
Replies (3)
Guest

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"))

Reply
On 12 April 2017 at 18:53
User Avatar

Accountant
23 Points Posted on 13 April 2017

How can I use this formula for multiple workbooks?

Reply
On 13 April 2017 at 10:27
User Avatar

Believe!! Live your dreams!
33521 Points Posted on 30 May 2017

why dont you submit test data...

Reply
On 30 May 2017 at 17:28


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Topic

More recent discussions | Post

Related Topics
Loading

Latest Job Openings

View all
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details