If cell A1 contains information from and cell in column C return value in column D at the same row as information.
<tbody>
Woolworths W7001 Sandy Bay
2004
United
2001
Dr Jay
2002
Sandy Bay Newsagent
2003
W7001
2004
Coles
2005
</tbody>
Thanks for your help!