Lengthy If Statement interpretation - HELP!

[jlugo]

Hello!

In layman's terms, would anyone explain how this formula operates? Forgive me I think I cut off the ending part -- which is only missing a few closing parenthesis....



=IF(ISERROR(VLOOKUP(Y19,'Z:\Models\Billing Model Report\7_July 2012\Contracts\[Missing Billing model Report Contract BCN 07232012.xlsx]View Export'!$D$7:$G$401,4,FALSE)),"N/A",VLOOKUP(Y19,'Z:\Models\Billing Model Report\7_July 2012\Contracts\[Missing Billing model Report BCN 07162012.xlsx]View</SPAN></SPAN>


I know it's looking up different sheets located located on the Z: drive of my computer and returning an "N/A" value instead of "N/A#".


Thanks in advance!

 

[Sal Paradise]

=IF(ISERROR(VLOOKUP(Y19,'Z:\Models\Billing Model Report\7_July 2012\Contracts\[Missing Billing model Report Contract BCN 07232012.xlsx]View Export'!$D$7:$G$401,4,FALSE)),"N/A",VLOOKUP(Y19,'Z:\Models\Billing Model Report\7_July 2012\Contracts\[Missing Billing model Report Contract BCN 07232012.xlsx]View Export'!$D$7:$G$401,4,FALSE))

That is the correct formula.

It is saying do this:
VLOOKUP(Y19,'Z:\Models\Billing Model Report\7_July 2012\Contracts\[Missing Billing model Report Contract BCN 07232012.xlsx]View Export'!$D$7:$G$401,4,FALSE)

If that is an error (there is no match), then return "N/A", otherwise return whatever value that formula gives.

 

[Trebor76]

Hi jlugo,

If there's an exact match to the entry in cell Y19 of the active sheet to cells D7:D401 of the "View Export" tab within the "Missing Billing model Report Contract BCN 07232012.xlsx" workbook, then the corresponding entry from G7:G401 of the "View Export" tab within the "Missing Billing model Report Contract BCN 07232012.xlsx" workbook is returned. If there's no exact match, then "N/A" is returned.

As you're using Excel 2007 (or later) you could also do the same, but more succinctly, using the IFERROR function that was released with that version.

HTH

Robert