try in C2
=if(B2="sheep",A2,"")
in D2
=if(B2="dogs",A2,"")
in E2
=if(B2="cats",A2,"")
and copy C2:E2
and paste as far down as you need

"sirgresley" wrote:

Having a senior moment.

I want to place values in columns.

EG
A2=25 B2=sheep C2=A2 all other columns (except A & B) blank
A2=25 B2=dogs D2=A2 all other columns (except A & B) blank
A2=25 B2=cats E2=A2 all other columns (except A & B) blank
and so on