Try something like this in C14:

=VLOOKUP(A14,O$9:P$1000,2,0)

and copy this down.

Your description is a bit fuzzy, so post back if this is not what you
want.

Hope this helps.

Pete



On Sep 22, 4:58*pm, Confusicous
wrote:
Here is my situation:
* * * * O * * * * * * * * * * *P
*9 *11/01/09 * *200 * * shares are * * *purchased
*10 01/15/10 * *-20 * * shares are * * *sold
*11 04/01/10 * *100 * * shares are * * *purchased
* * *08/15/10 * -200 * *shares are * * *sold
* * *10/31/10 * -80 * * shares are * * *sold

The first numbers are the row and O and P are the columns. My dates start in
A14 and go until A379. How do I get the Vlookup to get my data from O to
shoot the data from P into C14?