Spreadsheet: 93185d1292786474-how-do-you-match-2-columns-and-if-text-matches-display-info-from-3rd-column-to-a-4th-sampleworkbookoutcomeneeded
Sheet: Sheet1

Product ID | Price |  | Product ID2 | Outcome with [NAME] |  | Outcome I am looking For
C4965A | 504.124 |  | C4965A |  |  | 504.124
C5000A | 1200.652 |  | C5000A |  |  | 1200.652
C5001A | 1200.652 |  | C5001A |  |  | 1200.652
C5002A | 1200.652 |  | C5002A |  |  | 1200.652
C5003A | 1200.652 |  | C5003A |  |  | 1200.652
C5004A | 1200.652 |  | C5004A |  |  | 1200.652
C5005A | 1200.652 |  | C5005A |  |  | 1200.652
KSW-32 BLACK | 24.358 |  | KSW-32 BLACK |  |  | 24.358
KSW-64 BLACK | 36.538 |  | KSW-64 BLACK |  |  | 36.538
KSW-208 | 97.43800000000002 |  | KSW-208 |  |  | 97.43800000000002
CDW-64 | 36.538 |  | CDW-64 |  |  | 36.538
CDW-264 | 121.798 |  | CDW-264 |  |  | 121.798
F1D9000-10 | 55.396 |  | F1D9000-10 |  |  | 55.396
2200-06325-001 | 654.736 |  | 2200-06325-001 |  |  | 654.736
SV231USB | 240.322 |  | SV231USB |  |  | 240.322
RBC22 | 686.8240000000001 |  | RBC22 |  |  | 686.8240000000001
RBC23 | 1033.408 |  | RBC23 |  |  | 1033.408
RBC24 | 1219.804 |  | RBC24 |  |  | 1219.804
TLP602 | 19.108 |  | TLP602 |  |  | 19.108
TLP604TEL | 28.348 |  | TLP604TEL |  |  | 28.348
TLP808TEL | 88.19800000000001 |  | TLP808TEL |  |  | 88.19800000000001
TLP808TELTV | 102.898 |  | TLP808TELTV |  |  | 102.898
TLP810NET | 129.526 |  | TLP810NET |  |  | 129.526
TLP810SAT | 126.25 |  | TLP810SAT |  |  | 126.25
BK500BLK | 432.052 |  | BK500BLK |  |  | 432.052
SUPER7TEL | 66.86200000000001 |  | SUPER7TEL |  |  | 66.86200000000001
SUPER7TEL15 | 106.258 |  | SUPER7TEL15 |  |  | 106.258
U209-000-R | 53.212 |  | U209-000-R |  |  | 53.212
SUPER7 | 52.498 |  | SUPER7 |  |  | 52.498
PV1000HF | 709.294 |  | PV1000HF |  |  | 709.294
PV1800HF | 992.962 |  | PV1800HF |  |  | 992.962
BK350 | 295.3 |  | BK350 |  |  | 295.3
TLP808 | 62.62 |  | TLP808 |  |  | 62.62
SNMPWEBCARD | 775.78 |  | SNMPWEBCARD |  |  | 775.78
48121 | 55.48 |  | 48121 |  |  | 55.48
ST122PRO | 141.538 |  | ST122PRO |  |  | 141.538
C4890A | 744.154 |  | C4890A |  |  | 744.154
C4891A | 744.154 |  | C4891A |  |  | 744.154
C4892A | 744.154 |  | C4892A |  |  | 744.154
[NAME] | 744.154 |  | [NAME] |  |  | 744.154
4563A001 | 431.758 |  | F200-003-R |  |  | 510.7180000000001
1491A002 | 510.7180000000001 |  | 4563A001 |  |  | 15.454
636070 | 15.454 |  | 1491A002 |  |  | 127.132
PA410U | 127.132 |  | 636070 |  |  | 1019.254
67255 | 1019.254 |  | PA410U |  |  | 123.226
PS2408 | 123.226 |  | 67255 |  |  | 154.39
RS-1215 | 154.39 |  | PS2408 |  |  | 135.7
PS3612 | 135.7 |  | RS-1215 |  |  | 145.276
PS4816 | 145.276 |  | PS3612 |  |  | 170.56
PS6020 | 170.56 |  | PS4816 |  |  | 1448.41
BCPRO1400 | 1448.41 |  | PS6020 |  |  | 1411.618
OMNISMART1400 | 1411.618 |  | BCPRO1400 |  |  | 101.386
5165 | 101.386 |  | OMNISMART1400 |  |  | 1245.592
RBC12 | 1245.592 |  | 5165 |  |  | 21.67
A3L791-14-S | 21.67 |  | RBC12 |  |  | 114.91
49097 | 114.91 |  | A3L791-14-S |  |  | 243.808
[NAME] | 243.808 |  | 49097 |  |  | 270.73
93841 | 270.73 |  | [NAME] |  |  | 265.9420000000001
49107 | 265.9420000000001 |  | 93841 |  |  | 71.56600000000002
72121 | 71.56600000000002 |  | 49107 |  |  | 207.646
TSB212 | 207.646 |  | 72121