Matching cells

[Stephanie]

In column A I have a series of numbers which contains some
of the numbers in column D. Column E contains names that
are associated with the numbers in column D. Is there a
formula I can use so that the name from column E will be
copied into column B based on matching the numbers.

A B C D E
01 01 amy
05 02 jim
06 03 alice
04 tom
05 eric
06 lisa
In this case amy would copy to row 1 column B followed
under by eric in row 2 and lisa in row 3.

 

[Trevor Shuttleworth]

Stephanie

you can use VLOOKUP for this:

=VLOOKUP(A1,$D:$E,2,FALSE)

Regards

Trevor