Trying to create formula that updates another cell with a status.
Struggling where 0 value is returned during 1st count, it says 2nd check required when infact there should be no check.
Formula in column H
=if(g4=L4,"Correct Match","2nd Count Required")
Formula in Cell L (retrieving qty from another sheet)
=iferror(vlookup(a4,Sheet,4,false),"0")
Struggling where 0 value is returned during 1st count, it says 2nd check required when infact there should be no check.
Formula in column H
=if(g4=L4,"Correct Match","2nd Count Required")
Formula in Cell L (retrieving qty from another sheet)
=iferror(vlookup(a4,Sheet,4,false),"0")