How do I import an entire column from one sheet to another without getting #unparseable

I need all of the information entered in a column of sheet A to feed into sheet B. Does anyone have any advice for this?

This is the current formula we're trying that's showing up as unparseable: "=INDEX({A. Wash Schedule Range 1}, MATCH({A. Wash Schedule Range 1}),@row, 0)"

We're gotten "=INDEX({A. Wash Schedule Range 1}, 2)" to work but it will only pull over 1 row. When we try to drag it, it still only pulls over the same 1 row. Is there a way to have this formula to drag and drop? When we set it as a column formula, it puts the same value in the entire column.

Please help. I can not afford to use DataMesh. I was doing this in Google Sheets with a simple "ImportRange" formula.

Find more posts tagged with

Formulas

DataMesh

columns

INDEX

Accepted answers

All comments

Erin Horiuchi Green

Hello @Limi,

This is a bit tricky without a screenshot. You may have a formula format challenge.

Index function format= INDEX(Range, Row_Index, [Column_Index])

Range = {A. Wash Schedule Range 1}
Row_Index = MATCH({A. Wash Schedule Range 1})
Column_Index = @row

Why is there a 4th argument of ",0" in your Index formula?

=INDEX({A. Wash Schedule Range 1}, MATCH({A. Wash Schedule Range 1}),@row, 0)"

#UNPARSEABLE

Can you please try the below recommendation?

Range = Selection of Columns on Source Sheet. 1st Column is reference column. Last Column is targeted value.
Row_Index = MATCH(This should just be the reference column in the Source Sheet)
Column_Index = Last Column # of the Range.

Limi

Screenshot 2025-02-20 at 5.17.13 PM.png

I'm trying to set it up the way you suggested, it's coming back as Unparseable.

Amit Wadhwani

Can you try this formula?

Looks like you have created only one reference. Your formula refers to the same range for both INDEX and MATCH.

You need to create 2 references. I just posted an answer to a similar need. See this

https://community.smartsheet.com/discussion/136449/need-help-with-type-of-formula-to-use-vlookup-with-index-match-index-match-vlookup-if-and

Your second formula =INDEX({A. Wash Schedule Range 1}, 2) does not refer to any row for finding a match and therefore it is returning same data across.

Erin Horiuchi Green

Hello @Limi ,

Can you try the below?

= INDEX({Test 1 Range 1}, MATCH{Test 1 Range 5}, [Column_Index])

Column_Index = Column # that refers to the Results Column in your Cross Sheet Reference

If you want, you can share with me your mocked up Source and Cross Sheet Reference for a closer look.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.