Search code examples
imagegoogle-sheetstabs

Pull images from multiple sheets in Google Sheets - without Query! (because it does not recognize images in cells)

I am making a photo directory.

EDIT: Here is the example: https://docs.google.com/spreadsheets/d/1qo2ku9JuuNsX_v-D47nS8DLxvdqvpoNhRbZat2970Kw/edit?usp=sharing

I have one sheet with STAFF information that includes images in Column C. I have a second sheet with MEMBER information that also includes images in Column C. I want a third sheet to autofill first from STAFF and then from MEMBERS.

Query works great for all the data except the images. It appears not to recognize images in the cells as data. Even when I Query Column C alone it says there is no data.

Beyond query, most other formulas recognize photos in sheets and reproduce them in other sheets, including INDEX MATCH, FILTER, and a simple ARRAYFORMULA that pulls from a sheet with photos.

TO keep my third sheet flexible, so that it pulls all rows from STAFF and then all rows from MEMBERS, however long they may be, I'm looking for a single formula that could accomplish this.

Solution

  • You may try:

    =let(Σ,vstack(STAFF!A2:D,MEMBERS!A2:D),
     filter(Σ,choosecols(Σ,1)<>""))

    enter image description here