Vlookup

[PA'A HAU]

HELP!!!! i barely use vlookup... in my first sheet is a list of check numbers that were cut and in my second sheet is a list that were already cashed. what i want to do is compare the 2 lists and see which ones hasnt been cashed yet... please help thank you

 

[cstimart]

HELP!!!! i barely use vlookup... in my first sheet is a list of check numbers that were cut and in my second sheet is a list that were already cashed. what i want to do is compare the 2 lists and see which ones hasnt been cashed yet... please help thank you

Without having specifics of what you are trying to do...have you tried using the "Help on this function" in excel?

You'll also want to incorporate ISNA or ISERROR in what I think you're looking to do.