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

    Code
    =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:


    =IFERROR(your_formula,I6)

    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!

Register Yourself Login