Iserror statement interpretation

[jlugo]

Forgive me if this may be elementary to most!
Can someone please explain in a conceptual fashion what this means?

=IF(ISERROR(VLOOKUP($Z1,'C:\07232012.xlsx]00O80000004PWWQ'!$A$1:$T$82972,#REF!,FALSE)),"N/A",VLOOKUP($Z1,'C:\07232012.xlsx]00O80000004PWWQ'!$A$1:$T$82972,#REF!,FALSE))</SPAN>


Also, where did this value "00O80000004PWWQ" come from?
Any input would be great.
</SPAN></SPAN>

 

[Asala42]

The #REF! needs correction. It probably once refered to a cell containing an integer but then got deleted.

The formula is essentially just a vlookup.
- Lookup up the value in Z1
- In column A in the Range $A$1:$T$82972 on a worksheet named "00O80000004PWWQ" in the "07232012.xlsx" file.
- #Ref should be a number. The intent is to look in Column A of that range, find a match for the value in Z1, then pull the adjacent column number defined where #REF is. If you replaced the #REF with the number 3 for example, the formula would bring out the value in column C (3 columns in) where it finds the match in A.

The IF(ISERROR( function is a way to strip out errors, but you reference the main formula twice in the process. As in this pattern:
=IF(ISERROR(myformula),"N/A",myformula).

 

[Vidar]

deleted post...

 

[TheCman81]

Basically if the VLOOKUP returns an error, it will return "N/A" as the value in place of the error (which is an unusual value to return because that's class as an error!) And if no error is return it will carry the VLOOKUP formula!

The long number you're referring to, I can only imaging it's part of the file path to the spreadsheet