I need a formula for cell C8 that has four elements it looks at.
1. It will look at cell E8. If E8 = H2, then display the value in I2
2. If E8 = H3, then display the value in I3
3. If E8 = H4, then display the value in I4
4. If E8 = H5, then display the value in I5
Thank you in advance
1. It will look at cell E8. If E8 = H2, then display the value in I2
2. If E8 = H3, then display the value in I3
3. If E8 = H4, then display the value in I4
4. If E8 = H5, then display the value in I5
Thank you in advance