A
Anthony
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
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