Hi Steve,

Try this out.....

In F1 enter

=IF(ISERROR(VLOOKUP(E1,$A$1:$B$100,2,FALSE)),"",VL OOKUP(E1,$A$1:$B$100,2,FALSE))

Copy it down.

In G1 enter

=IF(ISERROR(VLOOKUP(E1,$C$1:$C$100,2,FALSE)),"",VL OOKUP(E1,$C$1:$D$100,2,FALSE))

Copy it down.

"Steve" wrote:

Hi,

I'm have the following sample of data from a worksheet in columns "A"
through "D". In column E I've managed to find a "COUNTIF" formula that
would uniquely identify all of the different items in columns "A" and
"C", i.e no duplicates....

Here is where I get stuck. I need new columns "F" and "G" (sample of
desired output shown) to assign corresponding values from columns "B"
and "D", respectively. Such that, the values from column "B" that have
the same matching number up to the decimal point (from the adjacent
cell in column "A") are matched up with the numbers in column "E" that
have the same number up to the decimal point and further aligned (in
the same row in columns "F" and "G") with the closest matching values
from column "D" that have the same number up to the decimal point from
the adjacent cell in column "C". Actually, if it helps I can lose the
decimal point numbers. I think the example might better explain what I
need, because this was very difficult to describe.


Thanks,

Steve

A B C D E F G
161.1 159 159.1 153 159.1 blank......
161.2 339 159.2 334 159.2 blank......
163.1 470 161.1 164 161.1 159 164
164.1 153 161.2 345 161.2 339 345
164.2 333 163.1 476 163.1 470 476
166.1 155 164.1 157 164.1 153 157
166.2 260 164.2 338 164.2 333 338
166.3 335 166.1 160 166.1 155 160
166.4 475 166.2 341 166.2 260 blank
170.1 156 166.3 481 166.3 335 341
170.2 336 170.1 161 166.4 475 481
172.1 158 170.2 342 170.1 156 161
172.2 338 172.1 163 170.2 336 342
174.1 471 172.2 344 172.1 158 163
175.1 472 174.1 477 172.2 338 344
176.1 157 175.1 478 174.1 471 477
176.2 337 176.1 162 175.1 472 478
blank...........................176.1 157 162
blank...........................176.2 337 blank