From memory and not at a PC to test this…
Use Match function to find the row in column C then Index function to find the corresponding value in column F. So the formula would be something like =INDEX(column F reference, MATCH(Col E value, column C reference, 0))
The zero in last argument for Match function is needed to get an exact match
Rather than using column references it’s easier to use named ranges and makes formula much more readable (worth finding out about named ranges if you don’t know what they are).
Hope this works!!