#### ddub25

##### Well-known Member
=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")

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

Can anyone help. Thanks.

Dan

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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")))

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 £

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

Dan

Replies
11
Views
625
Replies
2
Views
388
Replies
2
Views
176
Replies
4
Views
366
Replies
1
Views
282

1,203,525
Messages
6,055,916
Members
444,834
Latest member
ComputerExcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back