vlookup + if merging

[jayalaxmi]

Hi everyone,

Request you to help me with the formula..

=IF(VLOOKUP('Europe MTD'!$C5,'Week 3'!$C:$H,6,0)="None","None",IF('Week 3'!$H$3:$H$41="None","",VLOOKUP('Europe MTD'!$C5,'Week 3'!$C:$H,6,0)))

i need if the whole column Week 3'!$H$3:$H$41 is none i need it as blanks, if there are any values and none both in the column i need to display it as the values and none according to that. For that my vlookup will pick up the data for the same..

Thanks
Jaya

 

[rahulshewale1]

Hii @jayalaxmi ,

Could you upload sample file ? someone might be able to help you .

Regard
Rahul shewale

 

[Khalid NGO]

Hi,

Replace your 2nd IF with Countif.

Regards,

 

[GraH - Guido]

And IF ( ) could be simplified at first glance. The first one checks for "None" as result of vlookup and then returns "None". Seems redundant.

so per Khalid's suggestion, formula could be:
=IF(countif('Week 3'!$H$3:$H$41,"None"),"",VLOOKUP('Europe MTD'!$C5,'Week 3'!$C:$H,6,0))