VLOOKUP with INDIRECT

[Andrew_dot]

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 though.

I can get the forumla to work without the INDIRECT statement, so i am obviously using this wrong.

Can anyone point me in the right direction?

Thanks

Andrew

 

[SydneyGeek]

Try...

=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)))

Denis

 

[Andrew_dot]

Perfect. Thanks Sydney, i knew i wasn't far off.