Comparing cells to grab a value

[RodneyW]

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

 

[Fluff]

How about
=index(I2:I5,match(E8,H2:H5,0))

 

[RodneyW]

that works perfectly, thank you once again

 

[Fluff]

Glad to help & thanks for the feedback.

 

[RodneyW]

Looking for a bit of a modification. I need to move the data in columns H and I to a tab named Goals. How do I modify? Something like this: =index(goals!,I2:I5,match(E8,Goals!,H2:H5,0)) but that's not working.

Thanks again.

 

[Fluff]

Try
=index(Goals!I2:I5,match(E8,Goals!H2:H5,0))

 

[RodneyW]

YAHTZEE... that worked, thank you

 

[Fluff]

You're welcome & thanks for the feedback.