How about

=INDEX(Nationality!$B$5:$D$29,MATCH(Nationality!$A $5:$A$29,0),MONTH(date)-5)


maybe extend D29 out to your final month column

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ali" wrote in message
...
Hi Bob, thanks, still confused but no fault of yours- I am just a beginner
with these formulas.
First Worksheet

DATE: Aug o5
Jun Jul Aug
german 20% 5% 6%
French 11% 2% 8%
dutch 6% 4% 2%
As you type example Aug 05 next to DATE it reflects the Graph of August
because
SECOND worksheet has

% occupancy
German (and here is VLOOKUP formula as written above),
French
Dutch

I am sure this is simple to most but I am basically working backwards from
the formula to understand it and modify.
"Bob Phillips" wrote:

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?