Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Finding Data and Copying

Posted on 2013-06-03
Medium Priority
223 Views
I have a value in Sheet1 cell C1.  I need to search for this value on sheet 9 row 1.  When found, copy that columns data onto sheet 13 cell a1.
0
Question by:sandramac
[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
• Learn & ask questions
• 5
• 3

LVL 43

Expert Comment

ID: 39217079
If you find the value of C1 in D1 of sheet9 what do you want to put in sheet13?
0

Author Comment

ID: 39217119
I would like the data from D1:D25 into sheet13 A1
0

LVL 43

Expert Comment

ID: 39217140
Try entering this in A1 of sheet 13 and then copy down.
0

LVL 43

Expert Comment

ID: 39217147
=INDEX(Sheet9!1:1,,MATCH(Sheet1!\$C\$1,Sheet9!\$1:\$1,0))
0

Author Comment

ID: 39217162
Getting a N/A value.  In C1 i have the value of "KOTT"  in sheet 9 there is a string of data in each cell on row 1. Example of the data on sheet 9 is below

A1: KBUE 031752Z AO2 SLP134 T02440150 10244 20139 58011 \$
B1: KOTT 031752Z AO2  T02440150 10244 20139 58011 \$
C1: KRRE  031752Z AO2  T02440150 10244 20139 58011 4711 BKN

So I would need the data from B1,
0

LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 39217169
Then try

=INDEX(Sheet9!1:1,,MATCH(Sheet1!\$C\$1&"*",Sheet9!\$1:\$1,0))
0

Author Comment

ID: 39217180
It worked, just one other peice there is data listed below B1 doen to B50, how do i get it to copy B1 to B50.
0

LVL 43

Expert Comment

ID: 39217193
=Sheet9!B1

or

=Sheet13!B1

and then copy down
0

## Featured Post

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month4 days, 14 hours left to enroll

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

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