I need formula of vlookup for multiple workbooks

337 views 3 replies

Mohammed Kamran

Accountant

23 Points Joined February 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

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