Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with lookup and comparing values
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Spreadsheets | Excel Worksheet Functions |