look up

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I will have column B which I needs to be either a "Yes"
or "No" depending of what is entered in column C. There
are 36 possibilities for column C. Can someone tell me
the easiest way to auto fill "Yes" or "No" in column B?

thank you
 
frank said:
I will have column B which I needs to be either a "Yes"
or "No" depending of what is entered in column C. There
are 36 possibilities for column C. Can someone tell me
the easiest way to auto fill "Yes" or "No" in column B?

thank you
Click to expand...

Is there any particular logic as to which of Yes/No goes with each of the 36
possibilities? If so, perhaps you could tell us! If not, I suggest you make
a list of the 36 possibilities (say in Sheet2!A1:A36) along with the Yes/No
(in Sheet2!B1:B36. Then, in B1, use this formula:
=VLOOKUP(C1,Sheet2!$A$1:$B$36,2,0)
Drag this down column B as far as required.
 
Frank,
Since you have 36 possibilities for C I would suggest a lookup table:

On sheet2 enter your C values in column A and enter the corresponding yes or no in column B.

Now on sheet1 enter this formula in B1:

=VLOOKUP(C1,Sheet2!A1:B36,2,0)

If you don't wnat to see th #N/A when C is blank, then use:

=IF(ISNA(VLOOKUP(C1,Sheet2!A1:B36,2,0)),"",VLOOKUP(C1,Sheet2!A1:B36,2,0))


Good Luck,
Mark Graesser
(e-mail address removed)


----- frank wrote: -----

I will have column B which I needs to be either a "Yes"
or "No" depending of what is entered in column C. There
are 36 possibilities for column C. Can someone tell me
the easiest way to auto fill "Yes" or "No" in column B?

thank you
 
frank said:
I will have column B which I needs to be either a "Yes"
or "No" depending of what is entered in column C. There
are 36 possibilities for column C. Can someone tell me
the easiest way to auto fill "Yes" or "No" in column B?

thank you
Click to expand...

Frank,

The best way I can think is to create a simple two row table with the
36 possibilities for c in one column and their yes/no desired outcomes
in the second column. Then use a vlookup formula in colum B to
reference the table.

Good Luck,

Trevor L
 
Back
Top