I have been given a work book with three worksheets open.
In the Master I need to return if in a lookup the values match but from two places.
I have currently got the below in place but it only returns from the first sheet Tes Master not Tes Tony
=IF(C201057="ZF",VLOOKUP(A201057,'TES Master'!A:D,2,FALSE),VLOOKUP(A201057,'TES Tony Master'!A:D,2,FALSE))
Is there a way?
In the Master I need to return if in a lookup the values match but from two places.
I have currently got the below in place but it only returns from the first sheet Tes Master not Tes Tony
=IF(C201057="ZF",VLOOKUP(A201057,'TES Master'!A:D,2,FALSE),VLOOKUP(A201057,'TES Tony Master'!A:D,2,FALSE))
Is there a way?