Can one Excel cell be linked to different cell depending on what is typed in?

Nah thanks again : I will just go and get office 2007 hehe no bigy, one thing I encounterd while iporting data, for emxaple when I import lets say 500 gallons columb and then i import CA for california, it says 500 under AZ lol, - i can probubly swap and fix thos manulay though you done more then enough try it your self too, like drag the formula down and see if the same thing happens to you