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?