Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing codes with actual values
Hi all,
In an Excel document I have one worksheet "References" with in it a list of references and a ref code (1 to about 500). In the other sheet I have a dataset with for each observation a combination of references. Every observation can have anywhere between 0 and 10 references. The references for each observation are displayed horizontally, with in ech cell a ref code (i.e. 3 in D1, 78 in E1, 232 in F1 for observation 1 and 34 in D45, 56 in E45 for observation 45). Now, is there a way to replace the codes in the cells (1,2,3...) with the actual references? Do I need a macro for this? I would appreciate your help. Arjen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing codes with actual values
One possibility is to insert a new sheet and put formulae in cells to place
the references corresponding to the numbers. If "References" has the references in column A and ref code in column B and your observation are on Sheet1 then in you new (say Sheet2) sheet place this in D1 =IF(ISNA(INDEX(References!$A:$A,MATCH(Sheet1!D1,Re ferences!$B:$B,0),1)),"No ref found",INDEX(References!$A:$A,MATCH(Sheet1!D1,Refe rences!$B:$B,0),1) Copy across and down as required. HTH "Arjen" wrote: Hi all, In an Excel document I have one worksheet "References" with in it a list of references and a ref code (1 to about 500). In the other sheet I have a dataset with for each observation a combination of references. Every observation can have anywhere between 0 and 10 references. The references for each observation are displayed horizontally, with in ech cell a ref code (i.e. 3 in D1, 78 in E1, 232 in F1 for observation 1 and 34 in D45, 56 in E45 for observation 45). Now, is there a way to replace the codes in the cells (1,2,3...) with the actual references? Do I need a macro for this? I would appreciate your help. Arjen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing missing values? | Excel Worksheet Functions | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Replacing zero values with dashes | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |