bob dot phillips at tiscali dot co dot uk

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ali" wrote in message
...
Would be fantastic.. to what e-mail address do i send it?
Ali

"Bob Phillips" wrote:

You could mail it to me if you want. I am off for the afternoon, but
will
return in 5 hours.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ali" wrote in message
...
Hi, thanks for trying but I am getting way out of my depths. Will
only
understand it if I can show the existing graph to some-one who can
explain.

"Bob Phillips" wrote:

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?