lookup function

  • Thread starter Thread starter Dianne
  • Start date Start date
D

Dianne

I am trying to create a lookup function (with limited
knowledge).

I have a spreadsheet with two columns:

Column 1 will have codes like E-1, E-2 etc. I want to be
able to input the code in column and have the
corresponding information show up in column 2.

Example: COL 1 COL 2
E-1 PVT
E-2 PV2

Is this possible using a lookup?

Thanks,
Dianne
 
-example: using a table using CODE in column A1 and
Corresponding Info in column B1 and assume that your data
is entered in A1 to B25 ...then ...
-Alphabetize A1 to B25 with CODE column as the key
-Use =VLOOKUP(A1,A1:B25,2) to display the corresponding
info.
 
Back
Top