In an excel sheet I want to apply lookup formula only on rows with location “ATDF” keeping the rest of the rows as it is
I didn’t understand ur query can u please elaborate?
I have this excel file and I want to apply formula on column A for only those rows whose Column G value is ATDF
Nest the formula in an IF:
=IF(G2=“ATDF”, LOOKUP(your lookup logic),)
is there anyway to do this without iterating through the loop because I have more than 60k rows in an excel
You could use “Auto Fill Range” activity
In execution that will take literally a second or less. In debug it takes longer, but when running from Orchestrator it’s super quick