Forum Discussion
vlookup not working.
vlookup stopped working even in spreadsheets where it has worked before. when i hit "OK" after entering the data (it shows it has found the correct corresponding info) the function just hangs and does nothing. Neither the OK or Cancel button do anything. I have to x out.
5 Replies
That's better with sample. "it has worked before" - stopped to work on the same version of Excel or after you updated on dynamic arrays ? It doesn't work in the concrete file or in any workbook? Etc, etc. Just sample could answer on many questions.
here is a screen shot of the problem. when i hit OK it hangs and I have to x out. you can see it found the correct arguements. how do i attach or send the spreadsheet?
Bill_Bevers , thank you for the file. Unfortunately there was no formula in it you try to use. Anyway, I added formula and it works, please check attached.
Back to your screenshot
As variant Show Formulas is switched on in your file, perhaps something else.
Or you never clicked on Ok here
Above doesn't evaluate entire formula, it show you results for arguments (false in this case).
