In one workbook, I have a column A which A1 contains "Cities". In another workbook there is a "Cities" column, however, it's not in a static position. Is there a formula that I can use to look across Row 1, find "Cities", and list all the not empty cells in that column on my local workbook? Does excel have an array function similar to google sheets where I can type this formula one time in A2 on my local workbook to pull all of the 'x' number of values from the referenced workbook?
-
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.
Mirror column from another workbook that moves
- Thread starter lol.xls
- Start date
Similar threads
- Question
