Qualification > Miscellaneous

AICT Nov 2010 Problem

(1/1)

abdjed1:
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??

narnia:
check the attached file...
u have to use the concatenate function here alongwith text and lookup functions.

Navigation

[0] Message Index