F
Fiona
I am currently creating an Excel spreadsheet that looks up a city name and
returns the date from a different worksheet and gives me the ability to meet
a specific date month.
Worksheet 1
--Conditions--
City Name eg BRISBANE
Date: February
I want the formula to transpose the data for each row I have with the same
formula.
ie
A1 = BRISBANE
A2 = February 2008
Results
A5= 12 Feb 08
A6 = 26 Feb 08
A7= continues if data suits date condition and city condition.
Worksheet 2 sample data
eg columns and specific data
BRISBANE SYDNEY GOLD COAST
12-Feb 11-Feb 5-Feb
26-Feb 25-Feb 19-Feb
11-Mar 10-Mar 4-Mar
25-Mar 25-Mar 18-Mar
8-Apr 7-Apr 1-Apr
22-Apr 21-Apr 15-Apr
I would much appreciate some assistance with this query. I thought that I
could use the HLOOKUP feature, but I can't work out how to meet the
conditions and have it travel down the column as well.
Cheers
Fiona
returns the date from a different worksheet and gives me the ability to meet
a specific date month.
Worksheet 1
--Conditions--
City Name eg BRISBANE
Date: February
I want the formula to transpose the data for each row I have with the same
formula.
ie
A1 = BRISBANE
A2 = February 2008
Results
A5= 12 Feb 08
A6 = 26 Feb 08
A7= continues if data suits date condition and city condition.
Worksheet 2 sample data
eg columns and specific data
BRISBANE SYDNEY GOLD COAST
12-Feb 11-Feb 5-Feb
26-Feb 25-Feb 19-Feb
11-Mar 10-Mar 4-Mar
25-Mar 25-Mar 18-Mar
8-Apr 7-Apr 1-Apr
22-Apr 21-Apr 15-Apr
I would much appreciate some assistance with this query. I thought that I
could use the HLOOKUP feature, but I can't work out how to meet the
conditions and have it travel down the column as well.
Cheers
Fiona