Hello There!
I am using the CELL formula to locate the cell address with offset formula .which seems works fine..
here is the formula on Column E on my table below:
=IF(COUNTIFS($A:$A,A2,$C:$C,"Yes"),VLOOKUP(OFFSET(C2,0,-1),Sheet1!$A$1:$B$10,2,0),"others") ... the CELL Formula is in C2
the problem I m having is I cant get to populate the result on the entire Column E per groupings (as in Column A.)
Apologies.. I tried but I've literally been spending the last few hours trying to crack it but cant get it done.. Need your expertise please on how to do it.. Thanks in advance!
I am using the CELL formula to locate the cell address with offset formula .which seems works fine..
here is the formula on Column E on my table below:
=IF(COUNTIFS($A:$A,A2,$C:$C,"Yes"),VLOOKUP(OFFSET(C2,0,-1),Sheet1!$A$1:$B$10,2,0),"others") ... the CELL Formula is in C2
Column A | Column B | Column C | Column D | Column E |
IMS | Milk | No | Ok | #N/A |
IMS | Apple | Yes | Ok | Fruits |
IMS | Soda | No | Ok | #N/A |
IMS2 | Soda | No | Ok | #N/A |
IMS2 | Milk | Yes | Ok | Drinks |
IMS2 | Orange | No | Ok | #N/A |
the problem I m having is I cant get to populate the result on the entire Column E per groupings (as in Column A.)
Apologies.. I tried but I've literally been spending the last few hours trying to crack it but cant get it done.. Need your expertise please on how to do it.. Thanks in advance!