Autocomplete Cells from a different column?

Hi, I'm quickly chucking together a week planner for next season of iRacing.

I dont use excel much so the wording may be strange. Is it possible to use an autocomplete menu like picture 2 in the attached picture if i have the filled in values in seperate columns? I dont know if that makes sense or not or how obvious it is.

Thanks!

https://preview.redd.it/6ubc2dowy9hf1.png?width=2146&format=png&auto=webp&s=47ca54be7a54e2b0f437b39dd1105e4f281c5321