Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Lookup/Fill-in
This is a multi-part request for assistance. I've cross-posted this
message between two newsgroups because I'm not sure which of the two would be better to. Hopefully I have stated my concerns clearly! Here goes nothing: I have the following on Sheet1: TAM ID NSN NOMEN A0000 00000A 000-00-000-0001 Communication A0000 00001A 000-00-000-1001 Comm Gear 1 A0001 10000B 000-10-000-0001 Comm Gear 2 B0000 00000B 000-00-000-0002 Engineer C0000 00000C 000-00-000-0003 Miscellaneous D0000 00000D 000-00-000-0004 Motor Transport E0000 00000E 000-00-000-0005 Ordnance And on Sheet2 I have: TAM ID NOMEN I would like to type or lookup any of the three criteria and the other two be filled in automatically from the on Sheet1. On Sheet3 I have the following: ID Serial# OpStat The ID should be a lookup from Sheet1 and OpStat should be a lookup with the from the following table: STAT DESC AD Desc for AD SD Desc for SD CD Desc for CD CL Desc for CL RD Desc for RD Note: This table is also found in Sheet1 When the user types or mouses over a status code (AD, CL, etc...) I would like the description displayed for a few seconds. Finally I'd like to group Serial#'s from different TAM to form a system. For instance, Sheet4, Sheet5, and Sheet6 all have the same type of info as Sheet3 identifying different equipment. However for training Sheet3Row2+Sheet4Row17+Sheet6Row30 form a unique system. The OpStat of any individual item automatically becomes the OpStat for all other items in the system. Thanks in advance. Andrew |
#2
|
|||
|
|||
Andrew Edwards wrote:
This is a multi-part request for assistance. I've cross-posted this message between two newsgroups because I'm not sure which of the two would be better to. Hopefully I have stated my concerns clearly! Here goes nothing: I have the following on Sheet1: TAM ID NSN NOMEN A0000 00000A 000-00-000-0001 Communication A0000 00001A 000-00-000-1001 Comm Gear 1 A0001 10000B 000-10-000-0001 Comm Gear 2 B0000 00000B 000-00-000-0002 Engineer C0000 00000C 000-00-000-0003 Miscellaneous D0000 00000D 000-00-000-0004 Motor Transport E0000 00000E 000-00-000-0005 Ordnance And on Sheet2 I have: TAM ID NOMEN I would like to type or lookup any of the three criteria and the other two be filled in automatically from the on Sheet1. This portion of my problem is solved, utilizing the MATCH and INDEX functions I was able to devise a solution. =INDEX(Sheet1!$A$1:$D$3, MATCH($A2,Sheet1!$A$1:$A$3,), MATCH(B$1,Sheet1!$A$1:$D$1,)) I will continue to plug away at the rest but any assistance is greatly appreciated. On Sheet3 I have the following: ID Serial# OpStat The ID should be a lookup from Sheet1 and OpStat should be a lookup with the from the following table: STAT DESC AD Desc for AD SD Desc for SD CD Desc for CD CL Desc for CL RD Desc for RD Note: This table is also found in Sheet1 When the user types or mouses over a status code (AD, CL, etc...) I would like the description displayed for a few seconds. Finally I'd like to group Serial#'s from different TAM to form a system. For instance, Sheet4, Sheet5, and Sheet6 all have the same type of info as Sheet3 identifying different equipment. However for training Sheet3Row2+Sheet4Row17+Sheet6Row30 form a unique system. The OpStat of any individual item automatically becomes the OpStat for all other items in the system. Thanks in advance. Andrew |
#3
|
|||
|
|||
Andrew Edwards wrote:
Andrew Edwards wrote: This is a multi-part request for assistance. I've cross-posted this message between two newsgroups because I'm not sure which of the two would be better to. Hopefully I have stated my concerns clearly! Here goes nothing: I have the following on Sheet1: TAM ID NSN NOMEN A0000 00000A 000-00-000-0001 Communication A0000 00001A 000-00-000-1001 Comm Gear 1 A0001 10000B 000-10-000-0001 Comm Gear 2 B0000 00000B 000-00-000-0002 Engineer C0000 00000C 000-00-000-0003 Miscellaneous D0000 00000D 000-00-000-0004 Motor Transport E0000 00000E 000-00-000-0005 Ordnance And on Sheet2 I have: TAM ID NOMEN I would like to type or lookup any of the three criteria and the other two be filled in automatically from the on Sheet1. This portion of my problem is solved, utilizing the MATCH and INDEX functions I was able to devise a solution. =INDEX(Sheet1!$A$1:$D$3, MATCH($A2,Sheet1!$A$1:$A$3,), MATCH(B$1,Sheet1!$A$1:$D$1,)) I will continue to plug away at the rest but any assistance is greatly appreciated. Actually this only works based on the content of ColumnA. I wonder if this could be accomplished with a script? Any Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
How do I switch off automatic formatting (e.g. dates)? | Excel Discussion (Misc queries) | |||
Automatic backup copy | Charts and Charting in Excel | |||
how do you turn off automatic hyperlink in excel 2003 | Excel Discussion (Misc queries) | |||
automatic sequential numbering in excel or word | Excel Discussion (Misc queries) |