DOC: don't suggest melt instead of lookup
- [X] closes #45589
- [ ] tests added / passed
- [X] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit) for how to run them
- [ ] whatsnew entry

Thanks @adi611! The failures were unrelated  Thanks for giving me this opportunity. 