Thread: Need a formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default Need a formula

Column A Column B Column C Column D
0OK7 Haskell, OK 1ND3 =VLOOKUP(C2,A:B,2,0)
10XS Archer City, TX
1MO0 Dearborn, MO
1ND3 Kindred, ND



--
Allllen


"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....