Nested Vlookup Question

[matty_lou82]

I am using the following in order to establish if the data in Cell C appears in Column G, returning either Match or Non Match text as a result.

=IF(ISNA(VLOOKUP(C4,$G$4:$G$84,1,0)),"Non Match","Match")

I would like to add a third return text return option stating 'Blank', if there is no data in the respective cell in column C.

So in short, if the above vlookup is trying to lookup a cell that is blank, text stating 'blank' is returned.

Is this possible?

TIA,

 

[Craggs82]

=IF(C4<>"",IF(ISNA(VLOOKUP(C4,$G$4:$G$84,1,0)),"Non Match","Match"),"Blank")

like that?

 

[Fluff]

Another option

=IF(C4="","Blank",IF(COUNTIFS($G$4:$G$84,C4),"Match","Non Match"))

 

[matty_lou82]

=IF(C4<>"",IF(ISNA(VLOOKUP(C4,$G$4:$G$84,1,0)),"Non Match","Match"),"Blank")

Another option

=IF(C4="","Blank",IF(COUNTIFS($G$4:$G$84,C4),"Match","Non Match"))

Thank you ever so much

 

[Fluff]

Glad we could help & thanks for the feedback.