Howard,
Try this formula in Sheet1 B1 and fill down.
Code:=IF(ISNA(VLOOKUP(A1,'TB Consolidation'!$A$1:$A$20,1,FALSE)),"New Account","")
Howard,
Try this formula in Sheet1 B1 and fill down.
Code:=IF(ISNA(VLOOKUP(A1,'TB Consolidation'!$A$1:$A$20,1,FALSE)),"New Account","")
If you like the answer, please click " * " below Member name to say thanks.
Posting Permissions
Reply With Quote
Bookmarks