Vlookup help

  • Thread starter Thread starter Confusicous
  • Start date Start date
C

Confusicous

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?
 
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
 
Back
Top