Too many arguments for IF nested loops
Posted by gra on May 26, 2001 2:15 PM
ISLE OF DOGS b5 WEST END f5 EDMONTON k5 (AREAS)
POP b6 COV f6 BPK k6 (TOWN NAMES)
ADK b7 EUS f7 CLA k7 "
HAC b8 SOH f8 CED k8 "
UPK b9 HAM f9 EDM k9 "
CNW b10 BLO F10 FIN k10 "
MED b11 KEN f11 MUS K11 "
LOR F12 NWS K12 "
MAI F13 NFN k13 "
MAR F14 PGN k14 "
MAY f15 STA k15 "
PRI f16 TOT k16 "
NPN f17 "
My prob is: if I enter a 3alpha shortcode town-
name in B2 what formular must I input to C2 to make the respective area ie Isle of Dogs,West End or Edmonton, appear in C2. There are too many arguments(towns) for the IF function and I'm well and truly stuck. If anyone can help I'd be very much obliged.