Hi, i have 2 columns on a summary sheet using the 2 formula's below is there any way to combine these into 1 formula but still see the same results?, there are looking at the same unique reference on the summary sheet but referencing different cells on the signing's sheet.
=IF(ISNA(VLOOKUP(C13,'Signing's'!C:H,6,FALSE)),"No","Licence")
=IF(ISNA(VLOOKUP(C13,'Singing's'!AE:AF,2,FALSE)),"No","Revenue")
Any help appreciated
=IF(ISNA(VLOOKUP(C13,'Signing's'!C:H,6,FALSE)),"No","Licence")
=IF(ISNA(VLOOKUP(C13,'Singing's'!AE:AF,2,FALSE)),"No","Revenue")
Any help appreciated