I have two separate workbooks. I'm wanting to use an Array Formula to search through the external workbook, find the column header header "Si" and populate all external column data into my local workbook. Can I use Index/Match or Xlookup for this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Find Column Header From Another Workbook and Populate Column Data
- Thread starter lol.xls
- Start date
Similar threads
- Question
