Barren_Wuffett
New Member
- Joined
- Aug 6, 2019
- Messages
- 18
Hey everyone,
I'm trying to fill cell C17 by pulling values from columns C, E, or G using criteria C14 from criteria column B and criteria C15 from criteria columns D, F, and H. Example, if criteria are B and 1, then I'd want to pull cell E7 as shown below. I know it'll probably be some complex variation of index/match, array, etc. but I can't figure it out without using helper columns.
<tbody>
</tbody>
(Sorry, my work computer didn't allow me to use the tool to post a screenshot, so I hope the above works)
Thanks!
I'm trying to fill cell C17 by pulling values from columns C, E, or G using criteria C14 from criteria column B and criteria C15 from criteria columns D, F, and H. Example, if criteria are B and 1, then I'd want to pull cell E7 as shown below. I know it'll probably be some complex variation of index/match, array, etc. but I can't figure it out without using helper columns.
A | B | C | D | E | F | G | H | |
1 | ||||||||
2 | Tenant Name | $ | $ | $ | ||||
3 | A | 97 | 1 | 63 | 84 | |||
4 | A | 37 | 91 | 86 | 3 | |||
5 | A | 89 | 41 | 2 | 57 | |||
6 | B | 5 | 2 | 84 | 94 | |||
7 | B | 34 | 53 | 2 | 94 | |||
8 | B | 65 | 23 | 65 | 3 | |||
9 | C | 39 | 1 | 39 | 95 | |||
10 | C | 18 | 37 | 3 | 59 | |||
11 | C | 94 | 40 | 66 | 2 | |||
12 | ||||||||
13 | ||||||||
14 | Letter: | B | ||||||
15 | Number: | 1 | ||||||
16 | ||||||||
17 | $ Number: |
<tbody>
</tbody>
(Sorry, my work computer didn't allow me to use the tool to post a screenshot, so I hope the above works)
Thanks!