Hi James

is this what you're after
=IF(A1="Car",B1,C1)

Cheers
JulieD

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"James" wrote in 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"