Hi there I have a 2 sheets that i want to use.

The first sheet is a list of subject codes, names and prices etc;
MA081 Mathematical Methods $10.00
MA093 Specialist Maths $10.00
MATH1 Maths $10.00
MATH2 Maths $10.00

I want the second sheet to look at the first sheet and where the subject
codes match, display the name in one colum and the $ in second colum. My
currect formula is

=LOOKUP(E:E,'Fees '!A:A,'Fees '!B:B)

But the resluts are not right, in that for code MATH1 it is displaying the
MA093 results.

Please help!