Needing Help with an Iferror

Hi Guys, I am trying to create this complex query and having difficulty. Nothing I am doing is bring anything back or keeps telling me I have to few arguments for this function.

Basically column AD2 is my dollar amount and AL2 is by combo column that includes currency country and date. Than I am having my vlookup go and look at the FX table and column A is my combo of currency country and date. This is to bring back column E which is the conversation rate.

What I am need is for column AD2/column E( FX table) to bring back US currency. Bring back 0 if they do not match.


=iferror(AD2/vlookup(AL2),'FX 2016'!A:E,5,False)),0)

any help anyone could provide would be great!!!

Looks like you have some misplaced and extra parens..

Try

=iferror(AD2/vlookup(AL2,'FX 2016'!A:E,5,False),0)

Thanks everyone that worked perfectly!!!!

You're welcome.