Populate Cell Based on Matching Items

Hi. I’m needing some help with Excel.

I’m trying to write a formula/function for Row 20, Column H on my order entry worksheet. A typical scenario would be:

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”. And, if the word “batteries” were to be typed a second or third time anywhere between rows 3 and 150 in column E of my order entry worksheet, it wouldn’t make any difference because Row 20, Column H already has the word “batteries” there.

In summary, I’m trying to pre-fill the cell Row 20, Column H that is blank, with the word “batteries” IF it is found on the inventory worksheet. That word “batteries” would remain no matter how many entries of the word “batteries” in column E, rows 3 – 150 are entered.

I hope this makes sense. Thanks to anyone who can help.
Don