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"),""))

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • 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!