Auto fill & search in a list

  • Thread starter Thread starter Armadillo
  • Start date Start date
A

Armadillo

Using XL97 I need users to type in a number .i.e. 12001 which
automatically looks for a matching value in a list stored on another
sheet. 12001 = Farming,
thus returning Farming to a cell!

Please can anyone help?

Cheers Armadillo :-)
 
Armadillo,

Use vlookup.

=vlookup(a2,sheet1!A2:c2000,2,false)
where;
a2 is cell containing value to lookup (12001)
sheet1!a2:c2000 is the table containing the reference number and the
corresponding value
2 is the column in the table that contains the data to return
false means find exact match only.

Steve
 
Back
Top