edited 12/09/19 in Formulas and Functions

I am using a this Vlookup formula =VLOOKUP([Capex APR# / Opex WBS]1, {array}, 4, false)

This formula works ok and looks at data in the one sheet  {array}

due to the amount of data, two sheets are now required to be looked at by the formula how do I do this?




  • Frank Falco
    Frank Falco ✭✭✭✭✭✭


    =IFERROR(VLOOKUP([Capex APR# / Opex WBS]1, {array 1}, 4, false),VLOOKUP([Capex APR# / Opex WBS]1, {array 2}, 4, false))


    =IFERROR(VLOOKUP([Capex APR# / Opex WBS]1, {array 1}, 4, false),"")+IERROR(VLOOKUP([Capex APR# / Opex WBS]1, {array 2}, 4, false),"")

    The first option only does the second lookup if the first one fails. You could also wrap that in an IFERROR

    The second option tries both and returns blank if nothing is found.


    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

  • Dicko

    Thanks Frank works well


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!