[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: How can I look up values from another dataset..?
I have one dataset which includes the field postcode.
I have a second dataset which contains just 2 columns: postcode and area
I want to assign each observation in my first dataset to have an area code
(using the postcode).
If i were doing this in excel i could use the function "VLOOKUP",
unfortunately there are so many postcodes that i would have to use 17
worksheets for this exercise. Does anyone know how i could do this lookup in
Thanks in advance
L C Morecroft
Trent Cancer Registry
5 Old Fulwood Road, Sheffield, S10 3TG
Tel: 0114 226 3575
Fax: 0114 226 3561
* For searches and help try: