ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VLOOKUP problem - Never happened before (https://www.excelbanter.com/excel-discussion-misc-queries/130828-re-vlookup-problem-never-happened-before.html)

malycom

VLOOKUP problem - Never happened before
 
Problem resolved. There was a blank space at the end of the worksheet name.

Thanks for looking anyway.

"malycom" wrote:

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,'Febru ary 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



All times are GMT +1. The time now is 02:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com