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.
Need help to correct the error in the formula
-
-
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.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
