Automate column filling after search/lookup

Hello All,

I’m not sure if I need to use a lookup or a Macro.
I have a workbook that contains several columns on one sheetone of which notes “descriptions.” These descriptions vary. On another sheet there are several columns of “categories.”These columns have headers which is what the “descriptions on the first sheetare grouped under. How can I automate grabbing the “header” from sheet two intosheet one after a search is done for the “descriptions” in the individualcolumns on Sheet two?


I’m looking for a way to automatically fill column 5 withthe headers on sheet 2, (Dogs, cats, fish, pens, metal) IF the description in Column 4 on page one is anywhere on Sheet 2.
Please help or let me know if this is even possible. Thanks in Advance

Examples Attached
fill column.xlsx