Hi

I'm trying to use a vlookup function to reference against the table below

Column ref
A B C D

Jan Feb Mar
London 8 6 1
London 0 2 6
London 1 5 5
London 3 1 9
Paris 8 1 5
Paris 0 8 9
Paris 10 3 0
Moscow 4 8 5
Moscow 9 1 3
Moscow 1 1 5
Moscow 4 4 5
Moscow 0 3 2

Without using row references in the vLookup table array, I want to be able
to find the first Jan value for London (8), and then the second Jan value for
London (0), the third (1) etc down column B. Vlookup obviously finds the
first matching value in Col A only so will only give only the first row of
values in col's B,C, and D (8, 6,and 1). Is there any way to nest an offset
function so that excel can reference values in Col's B,C,D for all rows with
London (also Paris and Moscow) in col A?

Many thanks
--
Blacky_Oakes