Vlookup Problem: How to use on table with multiple rows?

[driverman13]

Hi,

I have a table with yearly data from 1927-2010 for 96 different stocks (Date and stocks are the headings horizontally along the top, data for each is in the column below the heading).

I have to change this table to monthly data (i.e. 1927/01,1927/02,..., 2010/12). For each month of the same year we use the data from the year in the original table (e.g. 1927/01-1927/12 all have to have the same value as our original 1927).

I have created a new blank table with dates from 1927/01-2010/12, a column for my vlookup 'lookup_value', and the 96 stocks. In the 'lookup_value' column i used =VALUE(LEFT(A88,4)) to fill it with the year i.e. 2010/12 turns into 2010.

Currently I am using the following vlookup command, but this only allows me to use it for the first stock in my table:

=VLOOKUP(B88,$A$2:$B$85,2,FALSE)

All columns are being filled with the stock1 values, how can I get stock 2 to fill with stock 2 values e.x.?

 

[abhi_vini]

can you attach a screen shot ?????

let me try to help you

 

[driverman13]

can you attach a screen shot ?????

let me try to help you

dont worry about it, fixed it thanks.