I use a macro to change information in csv files before importing into a
l;ivestock program.

The csv files always contains the same columns of info but vary in the
number of rows of information.

Part of my macro is to look at column A and depending on what each cell
contains place a letter in the coreesponding cell column G.

The formula is below but all that is happening is that it fixes cellA1 but
doesn't look at the other entries in column A

=LOOKUP(A:A,{"bull","cow","steer","weaner"},{"M"," F","S","U"})

What am I doing wrong

thanks