Lookup/Matching

[Scott]

I have two worksheets, one with 100 numeric codes in
column A and a value in column E, the other with 10
numeric codes in column A. In he second worksheet I need
to match the numeric codes in column A and return the
value in column E to a new column in the second worksheet
but I cannot get this to work, can anyone help ?

 

[Ken Wright]

With your data in A1:A100, E1:E100 on sheet 1, and A1:A10 on sheet 2

On sheet 2 in cell B2 put the following formula:-

=VLOOKUP(A1,Sheet1!$A$1:$E$100,5,0)

and then copy down to B10