VLOOKUP with INDIRECT

Andrew_dot

New Member
Joined
Sep 1, 2010
Messages
3
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

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

Forum statistics

Threads
1,082,570
Messages
5,366,364
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top