Forum Discussion
VLOOKUP values not updating
Hello,
It seems that two columns needs to meet condition column24 should be blank another column34 should be 0 right,
Code Column24 Column34
101 "" 0
102 1 0
103 "" 1
For meeting two conditions needs to add AND in the formula
=IF(AND(VLOOKUP(D2,$A$2:$C$4,2,FALSE)="",VLOOKUP(D2,$A$2:$C$4,3,FALSE)=0),"Rec'd","X")
Just try with same format with your formulas,
IF(AND(VLOOKUP(v2.2!$C$6,v2.2!$L$8:$II$51,24,FALSE)="",VLOOKUP(v2.2!$C$6,v2.2!$L$8:$II$51,34,FALSE)=0),,"Rec'd","x")
I hope that this will solve your issue.
Thanks
Hello Sivakumarrj and thank you for reaching out on this issue. Actually the column 24 and 34 are separate and distinct formulas meant to be triggered by two separate and distinct events as opposed to both being included in the same string. Essentially, IF this "VLOOKUP" result is an empty cell return "x" (tells me I still need to ask for that item from the opposing side) and if the result of that VLOOKUP is a cell with a value the result should be "Rec'd" (tells me the opposing side already responded to my request and I no longer need to ask them for that item). If >"" then "Rec'd" if not then "x".
Funny thing is that I corrected O, P & Q =IF(VLOOKUP(v2.2!$C$6,v2.2!$L$8:$II$51,24,FALSE)>"","Rec'd","x"
but the same correction didn't hold true with R. Thus far R has been corrected by reversing the order of "Rec'd and "x"
=IF(VLOOKUP(v2.2!$C$6,v2.2!$L$8:$II$51,34,FALSE)>"","x","Rec'd")
For God knows what reason that is working like clockwork...strange!
Thanks again for your insights!
