you're welcome ...
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"James" wrote in message
...
Many thanks (again) JulieD and Rowan.


-----Original Message-----
I have three columns of data, column A, B & C.

I want to write an IF statement that looks at column A,
and if it either retruns the contents of column B or
column C depending on the match.

eg.
Column A Car
Column B Non public transport
Column C Public transport

If column A = "Car" then return "Non public transport"
else
return "Public transport"



.