I am adding a constant to a value in a particular cell. I then want to search for that sum in a column. When the sum is found in that column, I want to use the value in the cell adjacent to the sum.
I am adding a constant to a value in a particular cell. I then want to search for that sum in a column. When the sum is found in that column, I want to use the value in the cell adjacent to the sum.
Would be nice to have a sample workbook so that we can the structure and data.
Given lack of details, sounds like you could use VLOOKUP or an INDEX-MATCH formula.
Provide more details for a more precise answer.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks