Spreadsheet: 92175d1291826072-multiple-vlookups-in-one-cell-excel-forum-test
Sheet: Pivot Table Data

Payment Received | (All)
W/E | (All)
 | Count of Current Billing Status
A+ Medical Company | 16
RR1402 | 1
2010-03-31 00:00:00 | 1
RR1413 | 1
no exchange | 1
RR1417 | 1
(blank) | 1
RR1437 | 1
(blank) | 1
RR1442 | 1
2010-05-20 00:00:00 | 1
RR1445 | 1
2010-06-06 00:00:00 | 1
RR1509 | 1
2010-07-21 00:00:00 | 1
RR1512 | 1
2010-07-14 00:00:00 | 1
RR1531 | 1
(blank) | 1
RR1537 | 1
2010-08-12 00:00:00 | 1
RR1538 | 1
2010-09-03 00:00:00 | 1
RR1543 | 1
no exchange | 1
RR1552 | 1
2010-08-18 00:00:00 | 1
RR1555 | 1
credit | 1
RR1575 | 1
credit | 1
RR1619 | 1
no exchange | 1
AAMC/Atlantic Biomedical | 2
RR1544 | 1
(blank) | 1
RR1610 | 1
no exchange | 1
AllParts | 4
RR1351 | 1
returned | 1
RR1371 | 1
no exchange | 1
RR1409 | 1
2010-04-06 00:00:00 | 1
RR1475 | 1
2010-06-12 00:00:00 | 1
Aramark | 1
RR1440 | 1
no exchange | 1
Aramark-Presb Albuqurque | 1
RR1478 | 1
2010-06-19 00:00:00 | 1
Aramark-Presbyterian | 1
RR1441 | 1
loan | 1
Classic Diagnostic Imaging | 29
RR1314 | 1
2010-01-20 00:00:00 | 1
RR1320 | 1
2010-02-13 00:00:00 | 1
RR1322 | 1
no exchange | 1
RR1329 | 1
2010-03-04 00:00:00 | 1
RR1330 | 1
(blank) | 1
RR1370 | 1
2010-03-10 00:00:00 | 1
RR1397 | 1
no exchange | 1
RR1418 | 1
no exchange | 1
RR1431 | 1
2010-05-18 00:00:00 | 1
RR1433 | 1
2010-05-18 00:00:00 | 1
RR1436 | 1
2010-05-18 00:00:00 | 1
RR1444 | 1
2010-05-25 00:00:00 | 1
RR1476 | 1
2010-06-18 00:00:00 | 1
RR1490 | 1
(blank) | 1
RR1501 | 1
[NAME] | 1
RR1506 | 1
2010-07-07 00:00:00 | 1
RR1507 | 1
2010-07-12 00:00:00 | 1
RR1508 | 1
2010-07-02 00:00:00 | 1
RR1518 | 1
(blank) | 1
RR1526 | 1
2010-07-26 00:00:00 | 1
RR1532 | 1
no exchange | 1
RR1534 | 1
2010-08-18 00:00:00 | 1
RR1549 | 1
no exchange | 1
RR1589 | 1
2010-09-24 00:00:00 | 1
RR1602 | 1
2010-09-21 00:00:00 | 1
RR1606 | 1
2010-09-22 00:00:00 | 1
RR1612 | 1
(blank) | 1
RR1617 | 1
(blank) | 1
RR1618 | 1
(blank) | 1
Curtis Bell | 1
RR1601 | 1
no exchange | 1
Express Systems | 22
RR1341 | 1
no exchange | 1
RR1356 | 1
no exchange | 1
RR1359 | 1
2010-03-27 00:00:00 | 1
RR1416 | 1
(blank) | 1
RR1443 | 1
2010-05-27 00:00:00 | 1
RR1479 | 1
no exchange | 1
RR1492 | 1
2010-08-05 00:00:00 | 1
RR1496 | 1
(blank) | 1
RR1500 | 1
2010-08-05 00:00:00 | 1
RR1511 | 1
** | 1
RR1527 | 1
no exchange | 1
RR1556 | 1
(blank) | 1
RR1559 | 1
(blank) | 1
RR1570 | 1
2010-08-24 00:00:00 | 1
RR1577 | 1
2010-09-23 00:00:00 | 1
RR1579 | 1
2010-09-10 00:00:00 | 1
RR1583 | 1
no exchange | 1
RR1587 | 1
2010-09-30 00:00:00 | 1
RR1609 | 1
2010-09-28 00:00:00 | 1
RR1613 | 1
no exchange | 1
RR1614 | 1
(blank) | 1
RR1616 | 1
(blank) | 1
MEC | 1
RR1461 | 1
(blank) | 1
Medical Equipment Corp | 1
RR1615 | 1
no exchange | 1
MEDSTAR | 1
RR1522 | 1
no exchange | 1
Parts Consulting Group | 13
RR1400 | 1
2010-04-05 00:00:00 | 1
RR1406 | 1
2010-04-14 00:00:00 | 1
RR1434 | 1
2010-05-18 00:00:00 | 1
RR1438 | 1
no exchange | 1
RR1439 | 1
(blank) | 1
RR1446 | 1
no exchange | 1
RR1448 | 1
2010-06-07 00:00:00 | 1
RR1464 | 1
no exchange | 1
RR1466 | 1
(blank) | 1
RR1502 | 1
no exchange | 1
RR1524 | 1
2010-08-05 00:00:00 | 1
RR1581 | 1
2010-09-21 00:00:00 | 1
RR1582 | 1
2010-09-12 00:00:00 | 1
PartsSource | 54
RR1316 | 1
no exchange | 1
RR1317 | 1
2010-01-15 00:00:00 | 1
RR1318 | 1
(blank) | 1
RR1325 | 1
01/21/2010 | 1
RR1331 | 1
2010-01-30 00:00:00 | 1
RR1339 | 1
no exchange | 1
RR1355 | 1
2010-03-23 00:00:00 | 1
RR1377 | 1
returned | 1
RR1390 | 1
2010-03-16 00:00:00 | 1
RR1392 | 1
2010-04-13 00:00:00 | 1
RR1393 | 1
2010-04-06 00:00:00 | 1
RR1394 | 1
2010-03-27 00:00:00 | 1
RR1395 | 1
2010-04-07 00:00:00 | 1
RR1396 | 1
2010-04-09 00:00:00 | 1
RR1401 | 1
no exchange | 1
RR1407 | 1
no exchange | 1
RR1410 | 1
2010-04-14 00:00:00 | 1
RR1411 | 1
2010-04-21 00:00:00 | 1
RR1412 | 1
2010-05-18 00:00:00 | 1
RR1419 | 1
no exchange | 1
RR1430 | 1
2010-05-18 00:00:00 | 1
RR1435 | 1
2010-05-18 00:00:00 | 1
RR1447 | 1
(blank) | 1
RR1463 | 1
2010-06-03 00:00:00 | 1
RR1467 | 1
no exchange | 1
RR1468 | 1
no exchange | 1
RR1472 | 1
2010-06-18 00:00:00 | 1
RR1477 | 1
no exchange | 1
RR1491 | 1
no exchange | 1
RR1494 | 1
2010-07-01 00:00:00 | 1
RR1495 | 1
(blank) | 1
RR1497 | 1
2010-06-23 00:00:00 | 1
RR1498 | 1
(blank) | 1
RR1519 | 1
2010-07-16 00:00:00 | 1
RR1521 | 1
2010-07-21 00:00:00 | 1
RR1523 | 1
(blank) | 1
RR1529 | 1
2010-08-18 00:00:00 | 1
RR1533 | 1
2010-08-05 00:00:00 | 1
RR1536 | 1
(blank) | 1
RR1539 | 1
2010-08-18 00:00:00 | 1
RR1553 | 1
2010-08-26 00:00:00 | 1
RR1557 | 1
2010-08-26 00:00:00 | 1
RR1571 | 1
2010-08-26 00:00:00 | 1
RR1572 | 1
2010-09-10 00:00:00 | 1
RR1574 | 1
2010-09-10 00:00:00 | 1
RR1576 | 1
2010-09-07 00:00:00 | 1
RR1578 | 1
[NAME] not sent | 1
RR1586 | 1
2010-09-21 00:00:00 | 1
RR1588 | 1
2010-09-30 00:00:00 | 1
RR1600 | 1
2010-09-21 00:00:00 | 1
RR1604 | 1
2010-09-28 00:00:00 | 1
RR1605 | 1
2010-09-30 00:00:00 | 1
RR1607 | 1
(blank) | 1
RR1611 | 1
2010-10-04 00:00:00 | 1
Philips Medical Systems | 3
[NAME] | 1
no exchange | 1
RR1504 | 1
(blank) | 1
RR1551 | 1
2010-08-27 00:00:00 | 1
ReMedPar | 85
RR1315 | 1
2010-01-21 00:00:00 | 1
RR1319 | 1
no exchange | 1
RR1321 | 1
no exchange | 1
RR1323 | 1
01/21/2010 | 1
RR1324 | 1
01/21/2010 | 1
RR1326 | 1
2010-01-28 00:00:00 | 1
RR1327 | 1
2010-01-28 00:00:00 | 1
RR1328 | 1
2010-02-04 00:00:00 | 1
RR1332 | 1
2010-02-14 00:00:00 | 1
RR1333 | 1
2010-03-04 00:00:00 | 1
RR1334 | 1
03/05/10 prob | 1
RR1335 | 1
2010-02-13 00:00:00 | 1
RR1336 | 1
no exchange | 1
RR1337 | 1
billed in full no exc | 1
RR1338 | 1
2010-03-13 00:00:00 | 1
RR1340 | 1
no exchange | 1
RR1342 | 1
billed in full no exc | 1
RR1343 | 1
2010-04-07 00:00:00 | 1
RR1344 | 1
2010-03-01 00:00:00 | 1
RR1345 | 1
2010-03-04 00:00:00 | 1
RR1346 | 1
2010-03-04 00:00:00 | 1
RR1347 | 1
03/04/101 | 1
RR1348 | 1
2010-03-04 00:00:00 | 1
RR1349 | 1
2010-03-10 00:00:00 | 1
RR1350 | 1
2010-03-04 00:00:00 | 1
RR1352 | 1
2010-03-10 00:00:00 | 1
RR1354 | 1
no exchange | 1
RR1357 | 1
no exchange | 1
RR1358 | 1
no exchange | 1
RR1372 | 1
no exchange | 1
RR1373 | 1
2010-03-23 00:00:00 | 1
RR1374 | 1
2010-03-16 00:00:00 | 1
RR1375 | 1
2010-04-09 00:00:00 | 1
RR1376 | 1
no exchange | 1
RR1378 | 1
2010-03-31 00:00:00 | 1
RR1379 | 1
no exchange | 1
RR1391 | 1
2010-03-27 00:00:00 | 1
RR1398 | 1
2010-05-19 00:00:00 | 1
RR1399 | 1
2010-04-05 00:00:00 | 1
RR1403 | 1
2010-04-14 00:00:00 | 1
RR1404 | 1
no exchange | 1
RR1405 | 1
no exchange | 1
RR1408 | 1
ret  2/13 | 1
RR1414 | 1
2010-05-18 00:00:00 | 1
RR1415 | 1
returned | 1
RR1432 | 1
2010-05-18 00:00:00 | 1
RR1449 | 1
2010-05-25 00:00:00 | 1
RR1460 | 1
2010-05-26 00:00:00 | 1
RR1462 | 1
2010-06-18 00:00:00 | 1
RR1465 | 1
(blank) | 1
RR1469 | 1
no exchange | 1
RR1470 | 1
2010-06-12 00:00:00 | 1
RR1471 | 1
2010-06-17 00:00:00 | 1
RR1473 | 1
2010-06-18 00:00:00 | 1
RR1474 | 1
2010-06-18 00:00:00 | 1
RR1493 | 1
2010-06-23 00:00:00 | 1
RR1499 | 1
no exchange | 1
RR1503 | 1
no exchange | 1
RR1505 | 1
2010-06-30 00:00:00 | 1
RR1510 | 1
(blank) | 1
RR1513 | 1
2010-08-22 00:00:00 | 1
RR1514 | 1
2010-08-18 00:00:00 | 1
RR1515 | 1
(blank) | 1
RR1516 | 1
per email restock | 1
RR1517 | 1
2010-07-26 00:00:00 | 1
RR1520 | 1
2010-07-23 00:00:00 | 1
RR1525 | 1
2010-08-06 00:00:00 | 1
RR1528 | 1
2010-08-05 00:00:00 | 1
RR1530 | 1
2010-08-18 00:00:00 | 1
RR1535 | 1
2010-08-18 00:00:00 | 1
RR1540 | 1
2010-08-12 00:00:00 | 1
RR1541 | 1
2010-08-11 00:00:00 | 1
RR1542 | 1
2010-08-12 00:00:00 | 1
RR1545 | 1
2010-08-11 00:00:00 | 1
RR1546 | 1
no exchange | 1
RR1547 | 1
no exchange | 1
RR1548 | 1
(blank) | 1
RR1550 | 1
2010-08-26 00:00:00 | 1
RR1554 | 1
(blank) | 1
RR1558 | 1
2010-08-24 00:00:00 | 1
RR1573 | 1
2010-09-07 00:00:00 | 1
RR1584 | 1
2010-09-15 00:00:00 | 1
RR1585 | 1
no exchange | 1
RR1603 | 1
2010-09-23 00:00:00 | 1
RR1608 | 1
no exchange | 1
SERVICE | 56
1450 | 1
no exchange | 1
1485 | 1
no exchange | 1
1486 | 1
no exchange | 1
1561 | 1
(blank) | 1
1562 | 1
(blank) | 1
1563 | 1
(blank) | 1
1590 | 1
(blank) | 1
1591 | 1
(blank) | 1
1592 | 1
(blank) | 1
1593 | 1
(blank) | 1
1594 | 1
(blank) | 1
1595 | 1
(blank) | 1
1596 | 1
(blank) | 1
1597 | 1
(blank) | 1
1598 | 1
(blank) | 1
1599 | 1
(blank) | 1
1620 | 1
(blank) | 1
1621 | 1
(blank) | 1
1622 | 1
(blank) | 1
1623 | 1
(blank) | 1
1624 | 1
(blank) | 1
1625 | 1
(blank) | 1
1626 | 1
(blank) | 1
1627 | 1
(blank) | 1
1628 | 1
(blank) | 1
1629 | 1
(blank) | 1
REL1360 | 1
no exchange | 1
REL1361 | 1
no exchange | 1
REL1363 | 1
no exchange | 1
REL1389 | 1
no exchange | 1
REL1422 | 1
no exchange | 1
REL1423 | 1
no exchange | 1
REL1424 | 1
no exchange | 1
REL1425 | 1
no exchange | 1
REL1427 | 1
no exchange | 1
REL1451 | 1
no exchange | 1
REL1454 | 1
no exchange | 1
REL1455 | 1
no exchange | 1
REL1458 | 1
no exchange | 1
REL1459 | 1
no exchange | 1
RR1366 | 1
no exchange | 1
RR1367 | 1
no exchange | 1
RR1369 | 1
no exchange | 1
RR1380 | 1
no exchange | 1
RR1381 | 1
no exchange | 1
RR1382 | 1
no exchange | 1
RR1383 | 1
no exchange | 1
RR1388 | 1
no exchange | 1
RR1452 | 1
no exchange | 1
RR1453 | 1
no exchange | 1
RR1456 | 1
no exchange | 1
RR1483 | 1
no exchange | 1
RR1487 | 1
no exchange | 1
RR1488 | 1
no exchange | 1
RR1560 | 1
(blank) | 1
RR1567 | 1
(blank) | 1
Service | 1
RR1484 | 1
no exchange | 1
SERVICE- Aramark | 2
RR1564 | 1
(blank) | 1
RR1565 | 1
(blank) | 1
SERVICE Parts Source | 1
RR1365 | 1
no exchange | 1
SERVICE Parts-Atlantic | 1
RR1457 | 1
[NAME] | 1
Service Reliant | 3
REL1420 | 1
no exchange | 1
REL1421 | 1
no exchange | 1
REL1429 | 1
no exchange | 1
SERVICE- Reliant | 3
REL1386 | 1
no exchange | 1
REL1566 | 1
(blank) | 1
REL1569 | 1
(blank) | 1
SERVICE/PARTS | 1
REL1362 | 1
EXCHANGE OK | 1
SERVICEAramark | 1
RR1384 | 1
no exchange | 1
Service-Aramark | 1
RR1481 | 1
no exchange | 1
Service-Dr. White | 1
RR1428 | 1
no exchange | 1
Service-Integrity | 1
RR1426 | 1
no exchange | 1
SERVICE-Masterplan | 1
RR1368 | 1
no exchange | 1
SERVICE-Reliant | 5
[NAME] | 1
no exchange | 1
REL1387 | 1
no exchange | 1
REL1482 | 1
no exchange | 1
REL1489 | 1
no exchange | 1
REL1568 | 1
(blank) | 1
Service-Renquest | 1
RR1480 | 1
no exchange | 1
SERVICE-Upper Chesapeake | 1
RR1364 | 1
no exchange | 1
(blank) | 1
1630 | 1
(blank) | 1
Grand Total | 316