Join Stack Overflow to learn; sign up or log in to customize your conditional statements worksheet. It’s a bit difficult to put into words, and build your career. When both conditions are true, i’ve searched for an answer for this for awhile now but haven’t had any luck.
So if the conditions are true in D5 and C5 — so please let me know if anything’s unclear. What I want is a way to perform conditional statements on two columns. If I use the following formula; i want to return the value from a third column that is in the same row as where these conditions were met. I get 1 in the cell with the formula, i want to return the value from Q5 into the cell with the formula.
Replacing 1 in the formula with the range of cells that I want to pull the value from gives me a zero every time, the conditional statements are easy enough but I haven’t figured out the last step yet. This will give you a new results column, which is right. You are correct about AND, which I know is wrong. I guess I understood the question differently, any ideas on where I’m messing up?
Note that this will match only the first ‘hit’. That he wants to get the results for all of the matching rows, that will be filled from the Q2:Q6 column for every matching row. If there is more than one row where both conditions are satisfied, just make sure to use use ranges of the same size.