If I have a possible 300 different instances in column "a" and column "b" is
always the same entry depending on what the instance is in the same row in
column "a", how can I create a function to automatically put the appropriate
entry into column "b" depending on what is in column "a"? The IF statement
would be way too large.
--
RedFive

Hi,

Somewhere out of the way build a table of your related values something like
this

cat dog
House caravan
This That

the in b1 enter the formula and drag down as required
=VLOOKUP(A1,L1:M3,2,FALSE)

this looks at the value in A1 finds it in column 1 of your table and returns
column 2

Mike
"RedFive" wrote:

If I have a possible 300 different instances in column "a" and column "b" is
always the same entry depending on what the instance is in the same row in
column "a", how can I create a function to automatically put the appropriate
entry into column "b" depending on what is in column "a"? The IF statement
would be way too large.
--
RedFive

Thanks Mike, exactly what I needed!
--
RedFive


"Mike H" wrote:

Hi,

Somewhere out of the way build a table of your related values something like
this

cat dog
House caravan
This That

the in b1 enter the formula and drag down as required
=VLOOKUP(A1,L1:M3,2,FALSE)

this looks at the value in A1 finds it in column 1 of your table and returns
column 2

Mike
"RedFive" wrote:

If I have a possible 300 different instances in column "a" and column "b" is
always the same entry depending on what the instance is in the same row in
column "a", how can I create a function to automatically put the appropriate
entry into column "b" depending on what is in column "a"? The IF statement
would be way too large.
--
RedFive