View Single Post
 
Old 10-24-2022, 01:51 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Maybe
Code:
=IF(XMATCH($E2,All!E:E,0)=XMATCH($B2,All!B:B,0);INDIRECT("All!E"&XMATCH($E2,All!E:E,0)),FALSE)
But something feels wrong there! You want to return from sheet All the value from column E (All!E210="Applications"), which must be same same as value in cell Data!E2 ("Applications"), plus some additional conditions! So why all this calculation? Why not simply
Code:
=IF(B2=E2,E2,FALSE)
Reply With Quote