Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperate -Lookup function needed!
Good Evening and thanks in ADVANCE for looking at my
problem. Please send me or reply with any code/equation idea that makes sense I have a workbook that contains 6 worksheets. 1=RegQList 2=289 3=Fisher 4=Grove 5=Sprauge 6=Mooney (Exactly as typed) I have in the RegQList hundreds and hundreds ,I think 2700 specific and unique Regulators that I need, no must calculate, various equations for. What I have figured out is that if I was smart enough to create a LOOKUP or smart eqations to find MAKE- Cell J2/MODEL-Cell K2/SIZE-Cell L2/ORIFACE-Cell M2 on each line in the RegQList then if you could help me create the code to look at the 5 other worksheets find the matching MAKE-Cell J2, then within that 1 of 5 sheets match-up MODEL/SIZE/ORIFACE (which on the 5 sheets is always column A-MAKE/B-MODEL/C-SIZE/D-ORIFACE when that match is located/solved I want the number known as Cg which is already in COLUMN E of the same Cell rows as the matching specific make regulator. I would like that number returned, or so I wish to place this lookup equation to place the Cg for each specific Regulator in AA2 of RegQList. Then with that Cg factor I can return to my basic Excel skills and create the needed equation of (1.29) X ( SUM H2+14.7) X (SUM AA2) this equals Q or Flow. The 1.29 and 14.7 are constant numbers to calculate Flow. I am going to play with this all night and morning. SO if you think that you can help me figure this out I would appreciate it so much I don't think you can even begin to understand. This is something that I was given months ago and I think was under the impression that the need for the data was disregarded and found out today that is needed tommorow. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperate -Lookup function needed!
If I understand your situation correctly.
create a dummy column that concatenates all your lookup information together. Then use a combination of Index and Match to find you information or the standard Vlookup function. You will have to check each of the other sheets separately. -- Regards, Tom Ogilvy "Krefty" wrote in message ... Good Evening and thanks in ADVANCE for looking at my problem. Please send me or reply with any code/equation idea that makes sense I have a workbook that contains 6 worksheets. 1=RegQList 2=289 3=Fisher 4=Grove 5=Sprauge 6=Mooney (Exactly as typed) I have in the RegQList hundreds and hundreds ,I think 2700 specific and unique Regulators that I need, no must calculate, various equations for. What I have figured out is that if I was smart enough to create a LOOKUP or smart eqations to find MAKE- Cell J2/MODEL-Cell K2/SIZE-Cell L2/ORIFACE-Cell M2 on each line in the RegQList then if you could help me create the code to look at the 5 other worksheets find the matching MAKE-Cell J2, then within that 1 of 5 sheets match-up MODEL/SIZE/ORIFACE (which on the 5 sheets is always column A-MAKE/B-MODEL/C-SIZE/D-ORIFACE when that match is located/solved I want the number known as Cg which is already in COLUMN E of the same Cell rows as the matching specific make regulator. I would like that number returned, or so I wish to place this lookup equation to place the Cg for each specific Regulator in AA2 of RegQList. Then with that Cg factor I can return to my basic Excel skills and create the needed equation of (1.29) X ( SUM H2+14.7) X (SUM AA2) this equals Q or Flow. The 1.29 and 14.7 are constant numbers to calculate Flow. I am going to play with this all night and morning. SO if you think that you can help me figure this out I would appreciate it so much I don't think you can even begin to understand. This is something that I was given months ago and I think was under the impression that the need for the data was disregarded and found out today that is needed tommorow. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperate -Lookup function needed!
Can you assist me with an example equation? I am willing
to try anything. -----Original Message----- If I understand your situation correctly. create a dummy column that concatenates all your lookup information together. Then use a combination of Index and Match to find you information or the standard Vlookup function. You will have to check each of the other sheets separately. -- Regards, Tom Ogilvy "Krefty" wrote in message ... Good Evening and thanks in ADVANCE for looking at my problem. Please send me or reply with any code/equation idea that makes sense I have a workbook that contains 6 worksheets. 1=RegQList 2=289 3=Fisher 4=Grove 5=Sprauge 6=Mooney (Exactly as typed) I have in the RegQList hundreds and hundreds ,I think 2700 specific and unique Regulators that I need, no must calculate, various equations for. What I have figured out is that if I was smart enough to create a LOOKUP or smart eqations to find MAKE- Cell J2/MODEL-Cell K2/SIZE-Cell L2/ORIFACE-Cell M2 on each line in the RegQList then if you could help me create the code to look at the 5 other worksheets find the matching MAKE-Cell J2, then within that 1 of 5 sheets match-up MODEL/SIZE/ORIFACE (which on the 5 sheets is always column A-MAKE/B-MODEL/C-SIZE/D-ORIFACE when that match is located/solved I want the number known as Cg which is already in COLUMN E of the same Cell rows as the matching specific make regulator. I would like that number returned, or so I wish to place this lookup equation to place the Cg for each specific Regulator in AA2 of RegQList. Then with that Cg factor I can return to my basic Excel skills and create the needed equation of (1.29) X ( SUM H2+14.7) X (SUM AA2) this equals Q or Flow. The 1.29 and 14.7 are constant numbers to calculate Flow. I am going to play with this all night and morning. SO if you think that you can help me figure this out I would appreciate it so much I don't think you can even begin to understand. This is something that I was given months ago and I think was under the impression that the need for the data was disregarded and found out today that is needed tommorow. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperate -Lookup function needed!
concatenating information
=A1&B1&C1&D1 assume insert a column so the concatenated column is the A column =B1&C1&D1&E1 Drag fill down the column. then to lookup =vlookup(A1,Sheet!!A1:Z200,6,False) Do this for each sheet and check which, if any returns something besides #N/A if isna(vlookup) -- Regards, Tom Ogilvy wrote in message ... Can you assist me with an example equation? I am willing to try anything. -----Original Message----- If I understand your situation correctly. create a dummy column that concatenates all your lookup information together. Then use a combination of Index and Match to find you information or the standard Vlookup function. You will have to check each of the other sheets separately. -- Regards, Tom Ogilvy "Krefty" wrote in message ... Good Evening and thanks in ADVANCE for looking at my problem. Please send me or reply with any code/equation idea that makes sense I have a workbook that contains 6 worksheets. 1=RegQList 2=289 3=Fisher 4=Grove 5=Sprauge 6=Mooney (Exactly as typed) I have in the RegQList hundreds and hundreds ,I think 2700 specific and unique Regulators that I need, no must calculate, various equations for. What I have figured out is that if I was smart enough to create a LOOKUP or smart eqations to find MAKE- Cell J2/MODEL-Cell K2/SIZE-Cell L2/ORIFACE-Cell M2 on each line in the RegQList then if you could help me create the code to look at the 5 other worksheets find the matching MAKE-Cell J2, then within that 1 of 5 sheets match-up MODEL/SIZE/ORIFACE (which on the 5 sheets is always column A-MAKE/B-MODEL/C-SIZE/D-ORIFACE when that match is located/solved I want the number known as Cg which is already in COLUMN E of the same Cell rows as the matching specific make regulator. I would like that number returned, or so I wish to place this lookup equation to place the Cg for each specific Regulator in AA2 of RegQList. Then with that Cg factor I can return to my basic Excel skills and create the needed equation of (1.29) X ( SUM H2+14.7) X (SUM AA2) this equals Q or Flow. The 1.29 and 14.7 are constant numbers to calculate Flow. I am going to play with this all night and morning. SO if you think that you can help me figure this out I would appreciate it so much I don't think you can even begin to understand. This is something that I was given months ago and I think was under the impression that the need for the data was disregarded and found out today that is needed tommorow. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Desperate help needed on formula | Excel Discussion (Misc queries) | |||
Lookup or reference function needed | Excel Worksheet Functions | |||
if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! | Excel Worksheet Functions | |||
Desperate Help needed with a function. | Excel Worksheet Functions | |||
Lookup help needed | Excel Worksheet Functions |