VLOOKUP problem - Never happened before

G

Guest

Hi

Could someone help with this VLOOKUP problem. I am using the followinf
=IF(ISERROR(VLOOKUP($A2,'February 2006
Loan'!$A$2:$AK$800,37,FALSE)),0,VLOOKUP($A2,'February 2006
Loan'!$A$2:$AK$800,37,FALSE)) in a spreadsheet but insted of pulling in data,
a dialog box opens as if I am supposed toi navigate to somewhere. This has
never happended before and I have done hundreds of these. Any ideas?

Thanks in advance.

Malcolm
 
G

Guest

pls ceck it out looking file is already opened ( 'February 2006 Loan') if it
is not then open or check the file name is proper.

pls do rating
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top