<div>
If you find the value of C1 in D1 of sheet9 what do you want to put in sheet13?
</div>


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

<div>
I would like the data from D1:D25 into sheet13 A1
</div>


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

<div>
Try entering this in A1 of sheet 13 and then copy down.
</div>


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

<div>
=INDEX(Sheet9!1:1,,MATCH(S<wbr />heet1!$C$1<wbr />,Sheet9!$1<wbr />:$1,0))
</div>


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

<div>
Getting a N/A value. &nbsp;In C1 i have the value of &quot;KOTT&quot; &nbsp;in sheet 9 there is a string of data in each cell on row 1. Example of the data on sheet 9 is below<br />
<br />
A1: KBUE 031752Z AO2 SLP134 T02440150 10244 20139 58011 $ &nbsp; <br />
B1: KOTT 031752Z AO2 &nbsp;T02440150 10244 20139 58011 $ &nbsp; <br />
C1: KRRE &nbsp;031752Z AO2 &nbsp;T02440150 10244 20139 58011 4711 BKN<br />
<br />
So I would need the data from B1,
</div>


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,

<div>
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.
</div>


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.

<div>
=Sheet9!B1<br />
<br />
or<br />
<br />
=Sheet13!B1<br />
<br />
<br />
and then copy down
</div>


=Sheet9!B1

or

=Sheet13!B1


and then copy down

<div>
<div class="content wysiwyg-content">
I have a value in Sheet1 cell C1. &nbsp;I need to search for this value on sheet 9 row 1. &nbsp;When found, copy that columns data onto sheet 13 cell a1.
</div>
</div>


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.

Finding Data and Copying

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.