| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Serious guidance needed....PLEASE
trying to perform a fill rate analysis
We were given two separate spreadsheets 1. Line Item Orders 2. Customer Shortages was told to use =order&"-"&item on in both sheets Then =IFERROR(VLookup(order/item,CustomerShortages,2, False),Order/item) There are approx 113000 lines on the Order sheet and only ~6000 on the shortages. I have the IFERROR formula on the order sheet and reference the shortages for ordered and shipped information. Yet all 113000 lines have something on them. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In need of more guidance please.... | Excel Programming | |||
| Need some guidance | Excel Worksheet Functions | |||
| Need code or just guidance!! | Excel Programming | |||
| Bob Phillips - guidance needed | Excel Worksheet Functions | |||
| Guidance needed wrkng with a wrksht | Excel Worksheet Functions | |||
Linear Mode
