Vlookup to return specific Text value

[lbanham]

Hi

I am using a Vlookup to check for a value between spreadsheets. This works fine and if found, returns the value and if not is shows as #NA.

I need to include a formula thats says, if the value is found "Reconciled" and if not "Not Reconciled".

I was using "ISERROR" to return a "0" instead of #NA but I still am unable to get it returning my "Reconciled" etc.

This is what i have so far.

=IF(ISERROR(VLOOKUP(C2,'Module Download'!C:J,7,FALSE)),0,(VLOOKUP(C2,'Module Download'!C:J,7,FALSE)))

Any help appreciated!

Thanks

 

[njimack]

=IF(COUNTIF('Module Download'!C:C),C2,"Reconciled","Not Reconciled")

 

[lbanham]

Thanks for that. I am looking for it as one whole forumula (i.e. all in one cell), is that possible?

 

[njimack]

Thanks for that. I am looking for it as one whole forumula (i.e. all in one cell), is that possible?

I don't understand. What do you want the formula to return?

 

[CharlesChuckieCharles]

IF(ISNA(Vlookup....

 

[CharlesChuckieCharles]

=IF(ISERROR(VLOOKUP(C2,'Module Download'!C:J,7,FALSE)),0,(VLOOKUP(C2,'Module Download'!C:J,7,FALSE)))

=IF(ISNA(VLOOKUP(C2,'Module Download'!C:J,7,FALSE)),"Not reconciled","Reconciled")

 

[lbanham]

Thanks, working perfectly.