Solved

How to copy and paste in Excel through a formula.

Posted on 2013-06-06
2
186 Views
Last Modified: 2013-06-06
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
Comment
Question by:claghorn
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 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

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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now