<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
I want to input Gender, ft, in, weight as in above and in cell J3 I want it look in the cells to the left and display either:
standard or prefferred.
In this case it is preferred. What formual can i use??
| Excel Workbook | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | * | * | preferred | standard | * | * | * | * | * | * | ||
| 2 | * | * | F | F | * | Gender | ft | in | weight | * | ||
| 3 | ft | in | weight | Weight | * | F | 6 | 0 | 132 | * | ||
| 4 | 4 | 6 | 74 | 94 | * | * | * | * | * | * | ||
| 5 | 4 | 7 | 77 | 97 | * | * | * | * | * | * | ||
| 6 | 4 | 8 | 80 | 100 | * | * | * | * | * | * | ||
| 7 | 4 | 9 | 83 | 103 | * | * | * | * | * | * | ||
| 8 | 4 | 10 | 86 | 106 | * | * | * | * | * | * | ||
| 9 | 4 | 11 | 89 | 109 | * | * | * | * | * | * | ||
| 10 | 5 | 0 | 92 | 112 | * | * | * | * | * | * | ||
| 11 | 5 | 1 | 95 | 115 | * | * | * | * | * | * | ||
| 12 | 5 | 2 | 98 | 118 | * | * | * | * | * | * | ||
| 13 | 5 | 3 | 101 | 121 | * | * | * | * | * | * | ||
| 14 | 5 | 4 | 105 | 125 | * | * | * | * | * | * | ||
| 15 | 5 | 5 | 108 | 128 | * | * | * | * | * | * | ||
| 16 | 5 | 6 | 111 | 131 | * | * | * | * | * | * | ||
| 17 | 5 | 7 | 115 | 135 | * | * | * | * | * | * | ||
| 18 | 5 | 8 | 118 | 138 | * | * | * | * | * | * | ||
| 19 | 5 | 9 | 122 | 142 | * | * | * | * | * | * | ||
| 20 | 5 | 10 | 125 | 145 | * | * | * | * | * | * | ||
| 21 | 5 | 11 | 129 | 149 | * | * | * | * | * | * | ||
| 22 | 6 | 0 | 132 | 152 | * | * | * | * | * | * | ||
| 23 | 6 | 1 | 136 | 156 | * | * | * | * | * | * | ||
Sheet2 | ||||||||||||
</body></html>
I want to input Gender, ft, in, weight as in above and in cell J3 I want it look in the cells to the left and display either:
standard or prefferred.
In this case it is preferred. What formual can i use??
