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

Limi · 02/20/25

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.

Erin Horiuchi Green · 02/20/25

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 · 02/20/25

Screenshot 2025-02-20 at 5.17.13 PM.png

Uploaded Feb 20, 2025184.16 KB

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

Amit Wadhwani · 02/21/25

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

Need Help With Type of Formula to Use (VLookup with Index/Match), Index/Match, VLookup/IF/AND??????

Syoung113

Feb 20, 2025

Hi, I have two sheets that I am trying to pull from. I want to pull the "Service Date" from the "Service Integration Sheet" and put it onto the "Account Management Sheet".
I am trying to match accounts that have completed their "Onboarding Call". The common variable on both sheets is the Sales Order Number, but I think the issue might be that there are several rows of the SO on the Service Integration Sheet. I have tried so many different formulas and they never work. I uploaded an Excel File with both sheets on separate tabs.
https://us.v-cdn.net/6031209/uploads/Y65ZPZGNEEE7/account-management-sheet.png
https://us.v-cdn.net/6031209/uploads/112C0EGQ59ZU/service-integration-sheet.png
https://us.v-cdn.net/6031209/uploads/G39JZEYBRPAS/smartsheet-formula.xlsx
Can someone help?

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 · 02/21/25

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.

Formulas and Functions

Formulas and Functions

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

Answers

Need Help With Type of Formula to Use (VLookup with Index/Match), Index/Match, VLookup/IF/AND??????

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

How to return the last recorded date in a column?

What am I doing wrong?

Nested IF Statements to Determine Priority