If statements

[TheRins3r]

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

 

[Fluff]

You need to use

=iferror(vlookup(a4,Sheet,4,false),0)

Otherwise the 0 is text & not a number.

 

[TheRins3r]

You need to use

=iferror(vlookup(a4,Sheet,4,false),0)

Otherwise the 0 is text & not a number.

Thanks for your help

 

[Fluff]

You're welcome & thanks for the feedback.