Vlookup issues, if no is data found

  • hi guys I an using a few vlookups and can not get the formula to work correctly the vlookups work but if no data is found I want it to =i6 here is the formula

    =UPPER(IF(ISNA(VLOOKUP(O6,'Wipedrive Report'!A:F,4,FALSE)),IF(ISNA(VLOOKUP(O6,'Asset Capture'!A:F,5,FALSE)),"",VLOOKUP(O6,'Asset Capture'!A:F,5,FALSE)),VLOOKUP(O6,'Wipedrive Report'!A:F,4,FALSE)))

    any help would be greatly appreciated.

  • Re: Vlookup issues, if no is data found

    Try this:


    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!