Forum Discussion
vlookup not working.
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).
- 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
If this option
is not available, you may share on OneDrive or like; or send Direct Message to me with file
