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

 

[Fluff]

It's not very clear what you want, but maybe

=IF(ISNA(VLOOKUP(C13,'Signing's'!C:H,6,FALSE)),"No","Licence")&" "&IF(ISNA(VLOOKUP(C13,'Singing's'!AE:AF,2,FALSE)),"No","Revenue")

 

[wildes]

Thanks for the quick reply, apologies i didn't explain myself well.

Your formula nearly did it, you can see in Test1 & Test4, the only issue is it says License or Revenue with a no afterwards, Test2 & 5 are my non combined ones, which is how it would like it to look if possible.

 

[Fluff]

Will the lookup value only be in one of the ranges?

 

[wildes]

No, the lookup value is in 2 columns, the first range is in column c, the second in column AE.

 

[Fluff]

So you want it to return one of
Licence
Revenue
Licence Revenue
Is that right?

 

[wildes]

If say, Test1 from column C is found on the signing's sheet it needs to say License, if Test4 from column AE it needs to say revenue, if nothing is found it can be blank or say no.

 

[Fluff]

What if Test1 is found in both col C & AE?

 

[wildes]

It won't be, Column AE is used for change requests that have a different ID

 

[Fluff]

Ok, how about

=IF(ISNA(VLOOKUP(C13,'Signing''s'!C:H,6,FALSE)),IF(ISNA(VLOOKUP(C13,'Signing''s'!AE:AF,2,FALSE)),"No","Revenue"),"Licence")