Lookup when lookup value is in middle of table

Hi there

I'm after some expert help once again. I want to know if it's possible to lookup a value that is in the middle of a table and return a cell that is in a column before the value?

example of lookup table attached. on the example i want to be able to search on the name and return the date of input. any ideas?