Hello formula experts
I am getting a value error in some cells where I am expecting B2C. I need your help to please correct the formula and get the correct result.
Hello formula experts
I am getting a value error in some cells where I am expecting B2C. I need your help to please correct the formula and get the correct result.
It usually helps if you explain the logic of what you want rather than leaving us to guess what a non-working formula should be doing. Maybe:
=IF(OR(P2={"B2C",""}),"B2C",IFNA(IF(VLOOKUP(P2,'GSTIN Verified'!$D$2:$H$16,5,0)="ACT","B2B","B2C"),""))
In column T I am getting a Value error. The result I am expecting is B2C as per the formula. If column P contains B2C it should display B2C. in column T. Again, If column P is blank then it should display B2C in column T.
Sorry, I didn't know you have already corrected the formula. It is perfect.
Thanks rory.
Don’t have an account yet? Register yourself now and be a part of our community!