Excel 2010 sort, find, match associated value

["wadekranz"]

When I type a GL code in a cell I need to match this GL Code in E91:E104 and drop the Project Name (cells F91:F104) value that matches the GL Code into the cell this formula is inserted in. Help please.

[Debraj Roy]

in just right cell of GL code use formula as.. (assuming you are entring GL code in A1, and putting below formula in B1

=vlookup(A1,E91:F104,2,0)

["wadekranz"]

Thanks, but I get #REF error. You assumed correct but I need to drop in B1 the matching value of the GL Code from F91:F104.
i.e when I type in A1 413000-47116 I want Tax Project to auto populate in B1.
GL Code Project Name
413000-47116 Tax Project
412000-41073 Release Program
413000-47132 Tax Project
413000-47155 Digital Strategy - MDM Online Statements (Digital Strategy)
413000-47133 Book Value
413000-47144 Tax Project
413000-47091 Fatca
413000-47141 PIC Back Office - 2013
413000-47168 PEI & BC Harmonization Project
413000-47171 FATCA
413000-47148 Rate Of Return (Net Invested Bar Charts)
413000-47032 2013 Spring Performance project
413000-47163 Alternative Investments Project
412000-41074 2013 Release Program

[Ace_XL]

Slight change to Debraj's formula..

In B1
=vlookup(A1,$E$91:$F$104,2,FALSE)
or
=INDEX($F$91:$F$104,MATCH(A1,$E$91:$E$104,0))

["wadekranz"]

Bravo! the =INDEX($F$91:$F$104,MATCH(A1,$E$91:$E$104,0)) did the trick, thank you so much.
Have a super day.
Wade