INDEX MATCH formula

[Sarath27]

Hi All,

Please help me understand how to transform this excel formula in Alteryx?

=INDEX('ICE PV Report'!$E:$E,MATCH('ICE Plex Report'!B2,'ICE PV Report'!$T:$T,0))

Thanks.

[binuacs]

@Sarath27 The index match function is similar to lookup function in excel , you can use the find and replace tool or join tool for your use case 

[kamal03]

Can you please provide a sample input and sample output file?