Conditional Values

[jdunkel]

I am trying to write a conditional formula. There are 4 columns. Column A will reflects if type product has been selected on another tab. An X is put in the cell based on input from the other tab. Column C is a description of the product. Column B is a value based on the description (1, 2, 3, 4, etc). Column D is where I want to capture the value that corresponds with Column A and B in Column D. So if there is no "X" in column A row 1 then there would be no value from column C put in column D. If row 3 had an X then I want the value in column B (3) to be put in column D. I tried IF Fomula =IF(A78=X,"1",IF(A78=0," "). This would not work I got an error message. I tried VLookup and got more confused. How can create this formula.
A B C D
_ 1 term _
_ 2 UL _
x 3 SUL 3
_ 4 WL _

 

[Diablo II]

use "" on text

=IF(A78="X","1",IF(A78=0," "))

 

[carsten]

the second if clause is redundant in my opinion.

=IF(A78="X","1"," ")

should be enough.

 

[carsten]

sorry. Didn't read carefully enough. The content of column B is missing so far.
Please try this:

=IF(A78="X",B78,"")

 

[jdunkel]

Thank you. I have saved my brain. =IF(A1="X",B2," ") worked great. I have one more favor to ask. I need to extrapolate it one more level.

I want a formula similar to the last last scenario and want to use the lesser of the total in the results column. But only if there is a second person. So in the example below I want to have the final result pick the value (from column B or D, rows 1 through 4) that is smaller when comparing the results of the last formula and put it in the appropriate column (F). If is not on a row by row basis, it is based on the results of the 4 rows. I can live with just a total filed and not worry about if it lines up horizontally. The lesser number is only used when there is a 2nd person. I can use another field (outside of the fields below to determine if there is a 2nd person).

1st person 2nd person
A B C D E F

_ 1 X 1 Male age 74 or less/ Female age 77 or less 1
X 2 _ 2 Male age 75 - 78/ Female age 78 - 81 _
_ 3 _ 3 Male age 79 - 83/ Female age 82 - 86 _
_ 4 _ 4 Male age 84 +/ Female age 87 + _