title: Check if text exist in rest of Column, and if so, use info from that row it is in
body: <p>I'm after a way to a cell to check another cell that I'm inputting text into, and for it to see if that text value is the same anywhere else in the column, and if so, it grabs the number value which is in the same column as itself but in the row of the text that checked for. </p>
  
  <p><img src="https://i.stack.imgur.com/MFEKu.png" alt="1]"></p>
  
  <p>So if you use picture, you can see I've currently got E7 selected. I'm wanting it to check the "GOLF COURSE" column for any other row that contains the same text it has in it's own row. For this it's "Course1". I'd like it to check through the rest of column B if there are any matches for "Course1" which there is in B3. If it matches I'm wanting it to then use the value that's in same column as it (E) but the same row as the matched text in column B. In this case I would want it to copy the value that is in E3.
  If there wasn't a match (as it's a new course lets say) then I need to be able to just click on the cell and input the numbers needed, which I would be able to do anyway but just throwing it in for sake of info. </p>
  
  <p>I've tried all sorts of googling and thinking how I could possibly do it but it's too difficult for my amateur knowledge of Excel. </p>