Equipment # and Equipment name

[Sumeluar]

Good day to all!
Here's my dilemma, I have two columns, A has the equipment #, B has the equipment name. On another work sheet I have a dropdown menu where I choose the equipment name. I have also to enter tne equipment name on a separate spot once I select the name. How do I select the name and have it to automatically enter the right number in a specific cell.

I want to select the equipment name in one cell and the equipment number in another, all done from the pulldown menu.

Thanks in advance!

Regards!
Sumeluar

 

[just_jon]

=INDEX(A:A,MATCH(C1,B:B,0))

Where C1 is your drop-down cell.

 

[Sumeluar]

Thanks just_jon, I gave it a try and it didn't seem to work. Am I missing something?

Regards!

 

[just_jon]

Thanks just_jon, I gave it a try and it didn't seem to work. Am I missing something?

Regards!

Sorry, yes - where X, insert sheet name

=INDEX('X'!A:A,MATCH(C1,'X'!B:B,0))

 

[Sumeluar]

Thanks again, Tried it and still didn't work!

Regards!