reference to other cell

Question

reference to other cell

Anonymous

Hello, I would like for a certain value to fill the cell with another value,as an example; if the result of the sum (F5) is equal to a value of H:H then the answer becomes J:J, so sum is 4 then 5, sum is 5 then 15, sum is 6 then 25, etc.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Accepted answer

2 additional answers

Answer 1

Dear respected Eelke van der Zwaag,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, using INDEX and MATCH

=IFERROR(INDEX(J:J, MATCH(F5, H:H, 0)), "")

If sum is 8:

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

HansV 460.7K MVP Volunteer Moderator

=XLOOKUP(F5, H4:H11, J4:J11, "-")

Answer 3

Anonymous

Thanks, that will work

mvg Eelke

Answer 4

Anonymous

Thanks, that will make my job a lot easier,

Greetings Eelke

Share via

reference to other cell

2 additional answers