View Single Post
  #1   Report Post  
Manos
 
Posts: n/a
Default vlookup function

Dear All

I have in sheet 1 , 12 columns with 100 rows data.
I sheet 2 i have an analytical analysis for 1 row.
So i want to bring in sheet 1 the value of only column from sheet 2.

So if i am in month 2 then the value comes to column 2 in sheet 1.

The problem is when i am changing the month and want to bring the value to
column 3 how it is possible not to change value in column 2?

I am using excel XP edition.

Thanks in advance
Manos