VLOOKUP FORMULA

[Navyasree123]

Hi all ,hope all are great ,i have query about the formula

=VLOOKUP(X4,Aging_Advt!$A:$H,8,0) how to write the logic for this formula in alteryx.

Thank you

[ShankerV]

Hi @Navyasree123 

The vlookup can be achieved with Join tool in alteryx.

Can I get sample input and expected output please to replicate the same in alteryx.

Many thanks

Shanker V

[Navyasree123]

Attached the input and output files

=MIN((IFERROR((VLOOKUP(X4,Aging_Advt!$A:$H,8,0)),0)),Y4) this is the formula i need to write the logic

[Raj]

Hi @Navyasree123 
the input you gave is not sufficient..

if possible you can share 2 records in an excel file with all the column and the result obtained by your formula i will be able to replicate the same in alteryx.

[Navyasree123]

@Rajattached file below

[Raj]

@Navyasree123  you have created lookup from another file.

kindly share the same as well

we will first join them and then apply the formula

[Navyasree123]

@Raji have attached the vlookup

[Raj]

Please find attached 
this will help.