Vlookup

Dicko

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

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.

 

Dicko

Thanks Frank works well