[Webinar] Streamline your web hosting managementRegister Today

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 230

# Finding Data and Copying

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
sandramac
• 5
• 3
1 Solution

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

Author Commented:
I would like the data from D1:D25 into sheet13 A1
0

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

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

Author Commented:
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

EngineerCommented:
Then try

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

Author Commented:
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

EngineerCommented:
=Sheet9!B1

or

=Sheet13!B1

and then copy down
0

## Featured Post

• 5
• 3
Tackle projects and never again get stuck behind a technical roadblock.