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

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:

Please Login or Register  to view this content.

not clear if wildcards are needed nor the name of your "Inventory" sheet - modify as necessary.