Hello!
I have three consecutive columns (B,C,D) and cells in these columns are filled with values or are empty.
Column J should display some text based on whether values in cells in columns G,H and I have certain values and those values correspond to a certain condition.
For example, B2 = 343, C2 = 319, D2 = 200;
my function should find these values in another sheet, check if the status is "done" for each of them, and put in J13 = "closed".
For another example, some B6 = 342, C6 = 319, but D6 is empty now, therefore nothing should be displayed in cell J13.
My basic formula that I am trying to expand is:
Formula:
=IFERROR(IF(VLOOKUP(B2,sheet2!B2:C5,COLUMNS(sheet2!B2:C6),FALSE)="done", "Closed",""),"")
I tried this:
Formula:
=IFERROR(IF(VLOOKUP(AND(B2,C2,D2),sheet2!B2:C5,COLUMNS(sheet2!B2:C6),FALSE)="done", "Closed",""),"")
but it is obviously incorrect as it doesn't check conditions for each cell, doesn't it?
Please, help me to find a smart solution, preferably based on mathematical approach.
Thank you very much!
Bookmarks