Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up formula
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up formula
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Schreeno" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up formula
Schreeno
You'll need 2 lookups - 1 for subject name the other for $amount. Try the following for subject name: =vlookup("subject code from sheet2" , Sheet!A1:C3 , 2 , false) and replace 2 above with 3 to get amount (based on the format ou gave in your question)/ Regards R "Schreeno" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|