Hi Guys,
I'm using this forumla;
=IF(ISNA(VLOOKUP(A3,(INDIRECT("'"&A5&"'!"))$A$6:$F$2560,6,FALSE))=TRUE,"Employee not found",(VLOOKUP(A3,(INDIRECT("'"&A5&"'!"))$A$6:$F$2560,6,FALSE)))
in an attempt to read from the array in the tab named in cell a5. I get a formatting error when i input it...