Automatic Lookup/Fill-in

A

Andrew Edwards

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
 
A

Andrew Edwards

Andrew said:
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.
Click to expand...

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.
 
A

Andrew Edwards

Andrew said:
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.
Click to expand...
Actually this only works based on the content of ColumnA. I wonder if
this could be accomplished with a script? Any Ideas?
 
Top