=IF(OR(B6={"$","€"}),VLOOKUP(B6,[RefHidden_110815.xlsx]Ref!$BV$5:$BY$60,MATCH(B6,[RefHidden_110815.xlsx]Ref!$BV$3:$BY$3,0)),"1")
Can anyone tell me why this formula is returning #N/A when there is a "€" in cell B6? The VLOOKUP references are correct and work becasue as I have another cell with a slightly different formula, but using exactly the same VLOOKUP references and it returns the correct results.
Is the formula possibly not composed correctly. Thanks.
Dan
Can anyone tell me why this formula is returning #N/A when there is a "€" in cell B6? The VLOOKUP references are correct and work becasue as I have another cell with a slightly different formula, but using exactly the same VLOOKUP references and it returns the correct results.
Is the formula possibly not composed correctly. Thanks.
Dan