Apply formula on filtered data only in |Excel

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

Hi @faiqaqureshi90

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

Cheers

In execution that will take literally a second or less. In debug it takes longer, but when running from Orchestrator it’s super quick