formula 3
Need a formula that says if cell = boat, then go to sheet2 and pull data.

thanks,
JaneS

I also don't know exactly what you mean, but I assume something like
this:
=IF(A1="boat",Sheet2!A1,"")