Finding values based on current month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’m using XL 2000

I have 48 columns, representing months Apr-06 thru Mar-07 (see January
example below)
Users enter a value under the ‘Cashable1’ column for the current month.
In Column 49, r4, I need to show the value in the Cashable1 column, r4 for
the current month.

This is Januarys’ layout. It is repeated for each month across the worksheet.

A B C
D
1 April
2 Latest Annual Estimate Actual
3 Cashable1 Non Cashable1 Cashable2 Non Cashable2
4 £0.000 M £0.000 M £0.000 M £0.000 M

r1 is ABCD merged and contains a month as text. (then the respective columns
for each month)
r2 is A+B merged & C+D merged (then the respective columns for each month)
r3 are my column headings (then the respective columns for each month)
r4 onwards are user data entry.

Any advice on a solution appreciated.
I'm assuming this is formula issue and not a VBA (formula preferred)
Thanks, Paul
 
Enter this formula in cell AW4:
=HLOOKUP(TEXT(TODAY(),"mmmm"),A1:AV4,4,FALSE)

Regards,
Stefi

„Paulc†ezt írta:
 
Thanks for the advice Stefi.
I considered this but Lookups by default like the table data sorted
alphanumerically, so lookups will always return August in data containing
months like mine for example.

Regards, Paul
 
No! HLOOKUP will find any month name in an unsorted table with a FALSE as 4th
parameter! Try it!

Regards,
Stefi

„Paulc†ezt írta:
 
Back
Top