Replicate Excel Formula

[Lizbhernan]

I am still building my first workflow and I am wondering how this formula can be replicated

 =[@[Eligible Hours]]*[@[Vacation Exclusion]]*IFNA(VLOOKUP([@[CO '#]]&[@[EPE'#]],Eligibility,@COLUMN(Eligibility[H&W (T/F)]),FALSE), TRUE)

I would really appreciate any help with this

[cjaneczko]

Use the join tool on your first table and your Eligibility Table. Join on CO# and EPE#. After the join, Union the J anchor with the L anchor. Add a formula tool after that to calculate your Hours times Exclusion using an IF formula to replace any Null values from the union.

[Qiu]

@Lizbhernan 

Welcome to the world of Analytic😁
Better to have a sample set data of input and  output.