I need to be able to pull data from a cell within the same worksheet based on the values contained in two other cells. For example if the value in cell M3 is “F” and the value in cell M6 is “12” then place the value in cell Q14 where this formula resides which is cell B4. This is the formula I have come up with but it does not return anything but there is no error either. =IF(AND(M3="F",M6="9"),Q11,IF(AND(M3="F",M6="10"),Q12,IF(AND(M3="F",M6="11"),Q13,IF(AND(M3="F",M6="12"),Q14,IF(AND(M3="M",M6="9"),Q6,IF(AND(M3="M",M6="10"),Q7,IF(AND(M3="M",M6="11"),Q8,IF(AND(M3="M",M6="12"),Q9,"")))))))) I can send a sample file once I see the paperclip.
This is the sample file:
Is anyone there?????
The other way around - if m3=f and m6=12 then the value in Q14 shoulg to B4 where this formula is.
Try this file as it has the formula in B4 that I am trying to use.
It is more complicated than what I sent the first time I think. There are 8 different possibilities that could happen.
Never mind I see what I was doing wrong I was placing quotes around the number and I saw what you had and now it works fine - THANKS!!!!