Linking tab 1 information to auto fill in tab 2 worksheet

Question

In excel 2010 how to you get it to imput a name associated with a number, ex. tab 1 has list of employees and equiptment with a number associated to each, on tab 2 in A1 I inputthe number 10, it auto inputs Joe Smith in B1 because it listed like that on tab 1

tab 1

joe smith -1

joe vos - 2

bob smith - 3

radio 14 - R14

radio 21 - R21

 

tab 2

A1 - I enter 1

B1 - auto enters Joe Smith

Answer 1

This may help.

http://office.microsoft.com/en-gb/excel-help/fill-data-automatically-in-worksheet-cells-HP001216366.aspx

Answer 2

You need to write an =if( ) function to do this.  It would look something like this

 

=IF(A1=Sheet1!B1,Sheet1!A1,IF(A1=Sheet1!B2,Sheet1!A2,0))

Place this in sheet 2 cell b1

This means that when you type 1 into sheet 2 in cell a1, cell b1 on sheet 2 will automatically be set to the value of cell b1 on sheet 1.