Help with list???

D

Dave

I have 2 worksheets, the first has a column titled SIC
Codes and the items in this column are four digit
numbers...on the second worksheet, I have 2 columns. The
first is a list of 4 digit numbers like the first
worksheet, the second column is the text value of that
code. For instance 5812 (first column) Eating
Establishments (second column). How do I get the first
worksheet to look at the first item in column 1 (four
digit number) and then either replace it with the text
value that it equals from the second worksheet, or I can
add a second column and put the value there.
 
N

Nikki

I can help you to add a second column. I am not sure how to replace it (you
could hide it).

=VLOOKUP(G12,J12:K15,2,FALSE) Use Vlookup -g12 is the SIC number on the
first workbook, j12:k15 is the second workbook's SIC code and word array,
2(the second column from the left) is the column that contains the word, and
false means it will only find an exact match. Put this code anywhere on the
first sheet and then fill it down.
 
A

Arvi Laanemets

Hi


With SIC codes on Sheet1 in column A, and the code table on sheet2 in range
A2:B100 (1st rows are for headers on both sheet), the formula in row 2 on
Sheet1:
=VLOOKUP(A2,Sheet2!$A$2:$B$100,2,0)


Arvi Laanemets
 
Top