If cell = value in column, get value from adjacent column

[leanheat]

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

[Glenn Kennedy]

Hi there... and welcome to the Excel Forum. Something like this, maybe?

=IFERROR(INDEX($B$1:$B$9,MATCH(C1,$A$1:$A$9,0)),"No match")

[samba_ravi]

Or
=iferror(vlookup(c1,$a$1:$b$9,2,0),"")

[leanheat]

That's perfect! Thank you Glenn!

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.