I$\text{'}$m trying to write a VBA sub that checks the value of a certain cell in a column, if there's a number there then i need it to save that number, save the content of the $2$ cells $($ii$.,$ iii.$)$ directly below it and the row name where it is and then paste it into specific cells $($cells will not be next to each other $[$material name can be pasted on A$7$ and below, i$.$ can be pasted on D$7$ and below, ii$.$ can be pasted on E $7$ below and iii. F$7$ and below on another table in a different sheet.The picture shown is a simplified version of what i have. On sheet $2$ i$\text{'}$d have a drop down list where the user picks the material they want. In this

example they chose "iron".Then what I want the sub to do is match the material name from all the columns on sheet $1,$ look down the matched column, check if there's a number $($not a $--)$ then paste back on sheet $2$ the name chemicals $($there might be more than one$)$ used and $3$ values as shown on the image attached. Thanks in advance!! will upvote if its correct