View original (French)

If my search is empty - enter another search

Solved
Claire -  
gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   -
Hello,

I want to know how to make it so that when my VLOOKUP = an empty cell, it does another VLOOKUP, but if my first VLOOKUP is filled, it should be taken into account.

I tried this formula but without success:

=IF(ISBLANK(VLOOKUP($A$11,Tableau2#Tout,4,FALSE)),"SO",VLOOKUP($A$11,Tableau2#Tout,6,FALSE))

Thanks in advance...
Claire

Configuration: Windows / Internet Explorer 11.0

5 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    Simply 
    =IF(VLOOKUP($A$11,Tableau2,4,FALSE)=0,VLOOKUP($A$11,Tableau2,6,FALSE),VLOOKUP($A$11,Tableau2,4,FALSE))

    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    1