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 d...
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).
- thanks, looks like the formula has changed and "false" is not a valid argument anymore. I have used "false" many times as the last arguement. The prompt used to say "false" returns the value in the lookup table. Thanks for your help. Mine works now if i dont say false