Pair columns and based on matching add a value from a third coumn

[ertert00]

Hi,

I have 3 columns (A, B, C), from where two (A, B) has matching numbers(id's) - but not all cases, and the 3rd column (C) contains values related to the 2nd column (B). I would like to pair the first two columns (A, B) and if there is a match, add the value from the 3rd (B) column.

example:

A B C
725 1078 0.82
863 1079 0.39
926 1080 0.62
957 1082 0.95
1078 1083 0.26
1080 1084 0.48
1082 1240 0.99
1240 1241 0.73
1242 1242 0.79
1244 1245 0.84
1245 1249 0.13
2256 0.25
2257 0.01
2258 0
2259 0.31
2260 0.11
2261 0.23
2262 0.03



This is how it should look after pairing:


957 - -
1078 1078 0.82
1080 1080 0.62

[bebo021999]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[ertert00]

Hi,

I have attached a sample worksheet.

Sample.xlsx

[bebo021999]

Try this array formula in H6:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

In I6:

=IF(H9="","",H9)

J6:

=IF(H9="","",VLOOKUP(I9,$B$2:$C$584,2,0))

Drag all down untill geting blank

[ertert00]

many thanks for the help!