IF with ISNA and VLOOKUP

[wildes]

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

 

[wildes]

Thanks you very much, this works perfectly

 

[Fluff]

You're welcome & thanks for the feedback.