Hi Trad,

Use VLOOKUP as below:

=VLOOKUP(C1,A$1:A$4,2,FALSE)

Thanks,

Shail

Trad wrote:
Its very simple. I want to input text into column C I want it to search
column A to find the same value and then return the results of column B.

Column A Column B Column C
0OK7 Haskell, OK
10XS Archer City, TX
1MO0 Dearborn, MO
1ND3 Kindred, ND

Many thanks....