Forum Discussion

Alex_Kim245's avatar
Alex_Kim245
Copper Contributor
Jan 31, 2023

Excel formula copy/paste help

Hello Experts,

 

I'm trying to copy some data into an existing spreadsheet with formula but getting value not available error. Could you shed some lights?

This is the data with formula to copy, 

=INDEX(Variables!$B$2:$B$9,MATCH(F4202,Variables!$A$2:$A$9,0))

and in a new row pasted, 

=INDEX(Variables!$B$2:$B$9,MATCH(F5341,Variables!$A$2:$A$9,0))

Any help would be greatly appreciated.

 

excel

7 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 31, 2023

    Alex_Kim245 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jan 31, 2023

        Alex_Kim245 

        Some users see an area "Drag and drop here or browse files to attach" below the box where you compose a reply.

        If you don't see that, you'll have to upload the file to a cloud service such as Google Drive or Microsoft OneDrive, share the file and get a link to the shared and uploaded file.

        Paste the link into a reply to this discussion.

Resources