Author Topic: AICT Nov 2010 Problem  (Read 1343 times)

Offline abdjed1

  • Newbie
  • *
  • Posts: 14
  • Reputation: 44
AICT Nov 2010 Problem
« on: March 19, 2011, 05:03:14 pm »
How do I do task 21:
"Insert a formula in cell K2 which uses the file NXMONTH.CSV to look up the season
from the Start date and adds this to the date.
For example: 01/01/2010 will be displayed as 01 January 2010 (Winter)"

I know the answer(checked the mark scheme) but can someone explain it to me??

Offline narnia

  • SF Immigrant
  • **
  • Posts: 100
  • Reputation: 59
Re: AICT Nov 2010 Problem
« Reply #1 on: March 23, 2011, 06:18:02 am »
check the attached file...
u have to use the concatenate function here alongwith text and lookup functions.