IFERROR Statement

[Harvey12]

Hi All,

I have recently been doing some work on confidential files that contain a formula which needs developing and I am really struggling with this.

Here is the formula that is currently used:

=IFERROR(VLOOKUP(A21,[Publicat.xls]Service!$C:$K,9,FALSE),"No")

What this formula does is take cell A20: These are part numbers for Service OR Operator manuals (Which can both be translated into 33 different languages). Then what is doing is looking through a large table which gives us all the info about that particular manual, in column 9 which is what I am getting the Vlookup to return is if that language is available. Unfortunately this formula only looks at the service manuals as seen written in the formula. I'd like to add a function to allow this to look at both tabs (Service and Operator), I am not sure how to get the formula to first search the Service tab and if it can't find the unique part number in there to search in the Operator tab and pull back the availability of languages.

Can someone please assist.

Many thanks
Harvey

 

[Harvey12]

*bump*

 

[Special-K99]

First, it's actually looking at cell A21 not A20.

Try

=IF(ISERROR(VLOOKUP(...Service...)),ISERROR(VLOOKUP(...Operator...)),"No")

if you see what I mean