Hi,

I have the current look up returning data of #N/A!;

=VLOOKUP(L66,'\\Via.novonet\dfs\LIFE\F\INVReporting\CONFIDENTIAL\Inv_Reporting_2012\Process Files\[Worldwide banks Exposure Template.xlsx]Sheet1'!A:B,2,0)&S66

Is it possible to add an IF function into this to say if it returns N/A then to populate the cell with 'Other'

Thanks