Lookup function
if any help about this problem, thanks
"Walley" wrote:
Hi
I have 13 worksheets, 12 of them represent months January to December, and
sheet nr 13 represent result of the year. I have a column in each sheet which
represent a month as C5:C26 which I add numbers to them every working day,
and I use the Lookup function ( €śLOOKUP(1E+100;C6:C25)€ť ) which return a
value before last empty cell. I want to have function to look to columns of
these sheets of months (jan to dec), and return a value before last empty
cell something like LOOKUP(1E+100; Jan2008!C6:C26,feb2008!C6:C25,€¦..to,
nov2008!C6:C27, dec2008!C6:C25)
Thanks in advance
|