Vlookup across several sheets

[KRKComputers]

Hello,

I am hoping that someone may be able to point me in the right direction. I am using the Vlookup "iferror" formula as shown below

=IFERROR(VLOOKUP(C7,'TABLE 1'!A2:D67,4,FALSE),IFERROR(VLOOKUP(MASTER COMPARE!C19,'TABLE 2'!A2:D21,4,FALSE),IFERROR(VLOOKUP(MASTER COMPARE!C19,TABLE 3!A2:D69,4,FALSE),"NOT APPLICABLE")))

First when I try to enter this into the cell and hit enter I get a window that pops up and wants to save my workbook, I also get no error however I am not able to read the items on TABLE 2 or TABLE 3 the code just skips to the end and states NOT APPLICABLE but it does read from TABLE 1 without any problems.

Can someone possibly tell me what I am doing wrong as it appears that Microsoft Excel does not even give me an error so I can look into things.

I am using Excel 2016

Thanks for the help
Kevin

 

[KRKComputers]

Hello,

I am hoping that someone may be able to point me in the right direction. I am using the Vlookup "iferror" formula as shown below

=IFERROR(VLOOKUP(C7,'TABLE 1'!A2:D67,4,FALSE),IFERROR(VLOOKUP(MASTER COMPARE!C19,'TABLE 2'!A2:D21,4,FALSE),IFERROR(VLOOKUP(MASTER COMPARE!C19,TABLE 3!A2:D69,4,FALSE),"NOT APPLICABLE")))

First when I try to enter this into the cell and hit enter I get a window that pops up and wants to save my workbook, I also get no error however I am not able to read the items on TABLE 2 or TABLE 3 the code just skips to the end and states NOT APPLICABLE but it does read from TABLE 1 without any problems.

Can someone possibly tell me what I am doing wrong as it appears that Microsoft Excel does not even give me an error so I can look into things.

I am using Excel 2016

Thanks for the help
Kevin

I have done some more digging on the web and have seen that some people are using and array to do what I am doing and based on that I am now curious if I should use an array or if I should continue with what I have here.

Can anyone tell me what if any are the benefits to me changing the code to an array versus iferror?

Thanks a bunch