Excel formula including Print_Area.

[IronHorseConsulting]

I am working on a revised to an excel spreadsheet I didn't create. I can't determine how the Print_Area is generated with this formula.

=IFERROR(IF('Warranty Parts Order Log'!I4="","",IF(C4>'Warranty Parts Order Log'!I4,"Claim is Filed",VLOOKUP(A4,'Warranty Parts Order Log'!Print_Area,10,0))),"")

The spreadsheet populates with a default phrase that I need to edit. But can't find where to edit it.

I am rather green with Excel so this may be a simple question that I'm just overlooking the solution to.

 

[jamtay317]

puah Ctrl + F3, select the named range that says Print_Area

 

[IronHorseConsulting]

I'm a Mac user. So that doesn't do anything in Excel