Hello,
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>May someone help me with a formula if possible for the following table. I see that a normal MATCH function is not working here.
In column A I have the CC values and in column B corresponding description for each value (CODE).
In Column D I have a list of numbers for which I want to look for the closest value in column A and if found put in column E the corresponding description (CODE). The values in red are the output desired for the input NUMBERS in D.
<tbody>
</tbody>
Thanks in advance for any help.
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>May someone help me with a formula if possible for the following table. I see that a normal MATCH function is not working here.
In column A I have the CC values and in column B corresponding description for each value (CODE).
In Column D I have a list of numbers for which I want to look for the closest value in column A and if found put in column E the corresponding description (CODE). The values in red are the output desired for the input NUMBERS in D.
CC | CODE | NUMBERS | CODE | |
---|---|---|---|---|
237 | CMR | 18763044 | JAM | |
230 | MUS | 187635 | JAM | |
61 | AUS | 23092 | MUS | |
31 | NLD | 3162 | NLD | |
599 | ANT | 38050 | NOT FOUND | |
358 | FIN | 33 | FRA | |
33751 | FRA | 49185 | NOT FOUND | |
65 | SGP | 51078 | NOT FOUND | |
1721 | SXM | 1246 | BRB | |
1876 | JAM | |||
81 | JPN | |||
124622 | BRB |
<tbody>
</tbody>
Thanks in advance for any help.