Hallo
I have two source files feeding into a report page. I need to extract
information based on matching cells in each of the files with the same set of
reference data. I have this formula which does the job:

=IF(ISNA(MATCH(Switches!B4,Computers!$A$2:$A$43,0) ),OFFSET(NonAuditableDevices.xls!$A$1,MATCH(Switch es!C4,NonAuditableDevices.xls!$A$2:$A$20,0),1),OFF SET(Computers!$A$1,MATCH(Switches!B4,Computers!$A$ 2:$A$43,0),6))

But if there are no matches with Switches!B4 in either the Computers or
NonAuditableDevices sheets it will return a #NA argument - what I really want
to do is leave the cell blank in that case. I thought adding an additional
ISNA function somewhere should help but can't seem to get it to work.