Linking words to values google sheets (excel)

As seen in the picture (My google sheet) I wish to create a statement that inputs the values of a given word. For example if i typed 'egg' into F10, the value for egg will be found in B:B and the corresponding value in C:C will be shown in F11.

The code I have so far for F11 is

=IF(ISNUMBER(SEARCH(B4,F10)),C4)

I wish to make this so it can search the column and not just one cell.

Thanks, J

My google sheet