Vlookup help

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?
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup help 2
Excel date formate doesn't change 0
Calculating Work Time 7
Reverse Index Match 2
Fals Result in IF Formula 1
time_report_date-wise_employee-wise 6
Summing like data 5
Formula ? 4

Top