Hi, is there a way to do this without macros or VBA, I want to do the following:

Lets say I have 2 columns A1:A9 and B1:B9 filled with values.
In cell C1 I enter a number
In cell D1 I want to the value of C1 to search through column A:A and if C1 matches with (lets say) A5, then I want the value of B5 to be retrieved to D1

Example of how it may look in excel

A1 B1 C1 (value input) D1 (value output)
A2 B2
A3 B3
A4 B4
A5 B5
A6 B6
A7 B7
A8 B8
A9 B9