This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I check coding on thousands of employee reimbursements each month. I have a list of things I will search to make sure I am catching all potential ways of wording something. For example, for cell phone and wifi reimbursements I check for cell, phone, wifi, Wi-Fi, and internet. I have a few of these search lists that I use to fix the GL codes that employees have entered.
I would like to semi-automate this process of searching so I'm thinking I need to do XLOOKUP combined with something like FIND or SEARCH so that I can maintain a list of search words and proper coding.
Does anyone know how to do this?
Subreddit
Post Details
- Posted
- 7 months ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...