Don, welcome to the board.
Please note your original title fell foul of Forum Rules and given first post I have on this occasion modified for you. Going forward please be sure to post in accordance with Board guidelines.

Originally Posted by
Don
If I type in the word “batteries” anywhere between rows 3 and 150 in column E of my order entry worksheet, then it would check my inventory worksheet in column B, rows 15 - 300 that has a list of electronic words for the word “batteries”. If the word “batteries” were found on the inventory worksheet, a different cell on the order entry worksheet (specifically, Row 20, Column H) would pre-fill with that word” batteries”.
I suspect there are other nuances yet to be covered but based on the above:
not clear if wildcards are needed nor the name of your "Inventory" sheet - modify as necessary.
Bookmarks