Nested If iserror with V lookup?

[barneyc]

Morning All,

I was wondering if someone could help me with the follwing formula, thats been buggin me for the past few days,

Im trying to do the following if this returns an error :
(VLOOKUP($B105,[Branches.xls]Branches!$B$3:$S$2000,18,FALSE

look at this :
(VLOOKUP($B105,[Branches.xls]Branches!$A$3:$S$2000,19,FALSE

if this also returns an error put a "-" in.

Whichever combination of formula i use i end up with "-" everywhere or #N/A's

Any help would be greatly appreciated.

Cheers

Barney

[zbor]

You can write:

=IF(ISNA(formula1), formula2, formula1)

[barneyc]

Welcome to Exceltip forum, Barney.

Question Not clear.
I do not quite understand what you are trying to accomplish. Could you please upload your workbook (after deleting any sensitive data) with a brief detail about what you need to achieve alongwith your expected results ?

Stormseed,

Thanks for your help, i have uploaded an example of my spreadsheet.
What i want to do is where the formula cant find the branch and produces a #N/A i would like to put a "-" in. Obviously without affecting its ability to pick up from the other two ranges.

Hope that makes more sense.

Cheers

Barney

[barneyc]

Hi Barney

I am sorry for this dirty long formula but I hope that it will do exactly what you look forward to accomplish Please check the attachment.

Is this what you want ?

Thats exactly what i want, thanks very much for your help.

Cheers

Barney