Help adding additional IF's

[ddub25]

=IF(OR(N18={"$","€"}),VLOOKUP(B18,[RefHidden_110815.xlsx]Ref!$BV$5:$BY$60,MATCH(N18,[RefHidden_110815.xlsx]Ref!$BV$3:$BY$3,0)),"1")

I'd like to add additional IF's to this formula so that

IF N18 = "£" then return "1"
IF N18 = "" then return "--"

Can anyone help. Thanks.

Dan

 

[Andrew Poulsom]

Like this?

=IF(OR(N18={"$","€"}),VLOOKUP(B18,[RefHidden_110815.xlsx]Ref!$BV$5:$BY$60,MATCH(N18,[RefHidden_110815.xlsx]Ref!$BV$3:$BY$3,0)),IF(N18="£","1",IF(N18="","--","1")))

 

[jasonb75]

Try

=IF(OR(N18={"$","€"}),VLOOKUP(B18,[RefHidden_110815.xlsx]Ref!$BV$5:$BY$60,MATCH(N18,[RefHidden_110815.xlsx]Ref!$BV$3:$BY$3,0)),IF(N18="£","1","--"))

This assumes that N18 ="" if it doesn't contain 1 of the 3 currency symbols, $,€, or £

 

[ddub25]

Thanks for both of your help. That's solved my problem. Thanks again.

Dan