Vlookup
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?
Comments

Try:
=IFERROR(VLOOKUP([Capex APR# / Opex WBS]1, {array 1}, 4, false),VLOOKUP([Capex APR# / Opex WBS]1, {array 2}, 4, false))
or
=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!

Thanks Frank works well
Help Article Resources
Categories
Check out the Formula Handbook template!