[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# How to copy and paste in Excel through a formula.

Posted on 2013-06-06
Medium Priority
233 Views
I've been trying formula's like vlookup, index, match etc... from previous solutions with no luck so I'm writing this request.
Can you tell me how to search for a value from col c in col m and when found in col m fill in the corresponding value from col a into col d.

col a range is A2:A53
col c range is C2:C53
col d range is D2:D619

the match search range is M2:M619

Does each cell in the D column need a formula?
Is this better solved using VB Script?
0
Question by:claghorn
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 39226283
This is what I have understood from your description.

Enter this formula in D2 and copy it down.

=iferror(index(\$A\$2:\$A\$52,match(m2,\$C\$2:\$C\$53,0)),"")
0

Author Closing Comment

ID: 39227052
It does exactly what I asked. Thanks so much.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month14 days, 15 hours left to enroll