<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
I have a formula in K5 above it takes the G5, H5, I5, J5 and it matches with column A,B,C,D to get the result in K5. It works however in columns A,B, C, D, E I have a lot of data… this is a small sample. To reduce the data I would like to create a formula like the one above but in column C I would like to create a match function for weight that searches in between (greater than or less than) two sets of numbers like displayed below…How do I do that?
<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
Excel Workbook | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | * | * | * | * | * | * | * | * | * | * | * | * | ||
2 | Ft | in | weight | G | Class | * | * | * | * | * | * | * | ||
3 | 4 | 11 | 88 | F | Standard | * | * | * | * | * | * | * | ||
4 | 4 | 11 | 89 | F | Standard | * | Gender | ft | in | weight | * | * | ||
5 | 4 | 11 | 90 | F | Standard | * | f | 4 | 11 | 88 | Standard | * | ||
6 | 4 | 11 | 91 | F | Standard | * | * | * | * | * | * | * | ||
7 | 4 | 11 | 92 | F | Standard | * | * | * | * | * | * | * | ||
8 | * | * | * | * | * | * | * | * | * | * | * | * | ||
Sheet |
</body></html>
I have a formula in K5 above it takes the G5, H5, I5, J5 and it matches with column A,B,C,D to get the result in K5. It works however in columns A,B, C, D, E I have a lot of data… this is a small sample. To reduce the data I would like to create a formula like the one above but in column C I would like to create a match function for weight that searches in between (greater than or less than) two sets of numbers like displayed below…How do I do that?
<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
14 | Ft | in | Weight | Weight | G | Class | ||
15 | 4 | 11 | 88 | 115 | F | standard | ||
16 | 4 | 11 | 116 | 174 | F | standard+ | ||
17 | 4 | 11 | 175 | 5000 | F | decline | ||
Sheet |
</body></html>