Forum Discussion
Solved
Help with an Excel Formula/Command Please
Good Afternoon, I need help with a formula which I am trying to put into an Excel Spreadsheet please. I'm not sure how to do what I want to do. Please See The Diagram Below. I am wanting to put...
- Glad to help. Based on your screenshots, I thought cells I3:I6 were merged, which means the value is stored in I3. It looks like you merged I4:I6, which is why your correction worked! I really glad that this caused you to do some research and learn about some awesome formula capabilities in Excel.
Please mark one of my responses as the Best Response. Thanks!
You can use nested IF statements to achieve the desired result. This should work:
=IF(I3=G3,H3,IF(I3=G4,H4,IF(I3=G5,H5,IF(I3=G6,H6))))
If this answers your request, please consider marking it as the approved solution. Thank you!
I'm looking around on this page but I'm still struggling 😞
https://support.microsoft.com/en-us/office/if-function-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8
