=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MON TH(date)-6, MON
I don't get two things.
Why are you using VLOOKUP with a single column, VLOOKUP works on multiple
columns to pull back a value from an offset column.
Why not just use MONTH(date)?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Ali" wrote in message
...
=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MON TH(date)-6,
MONTH(date)+6))
Creating a worksheet with a graph that reflects nationality of visitors to
a
lodge. As you type the Month at the top of the worksheet, the graph
reflects
the said month. Previous example commenced season in July with above
formula.
So, if you type in July 05, the graph reads from the 1st column and July
is
chartered. Type Dec and a graph for december is reflected.
I need to alter to commence season in June, and not July but now graph is
not reading correctly. How do I alter formuala or spreadsheet that season
now commences in June of the year?
|