retrieve data

[Guest]

My query


sheet1 data looks like this

A B c D E F
Head 1 2 3 4 5---------
1_5 23 34 5 6 7-------------

In Col B,C,D-- we have values for each week data and goes thru the whole
year till IV.

In sheet2

A b c d e f---
1-5 Value

I want in sheet2 the data to be displayed for two months. It counts the
across the whole column
find the last empty colmmn and get the data for last two months which is
there. It is variable becoz everymonth data
comes in.
Write now I am using vlookup to do that but it is a very tedious process.As
the months increases.
Any help would be greatly appreciated.




thanx in advance.

 

[duane]

it sounds like you want to make your vlookup something lik
=vlookup(what, where,count of data)

where count of data is count(sheet1!b2:iv2) - or whatever row woul
have the # of data points in it