Lookup and put match in next column

As you can see in image and excel attachment i have two columns.
i want to lookup a value greater then or equal to 1000 and after first match with value(=>1000) corresponding depth must be printed.
Thanks in advance.

It is not clear what you ask for.

Please show on sheet the answers you expect to see.

Regards,

David