Hello:
I have a question in regards to looking up a value from a list not in ascending order. I am not sure what formula(s) to use to return the value needed. I have tried using the index and match formula, but the result comes up as #NA. Any help would be appreciated.
<tbody>
</tbody>
Thanks!
I have a question in regards to looking up a value from a list not in ascending order. I am not sure what formula(s) to use to return the value needed. I have tried using the index and match formula, but the result comes up as #NA. Any help would be appreciated.
Supplier | Yearly Spend | Top X Data SupplierX | Yearly SpendX |
SupplierA | $1,552.00 | SupplierV | 1804 |
SupplierB | $1,564.00 | SupplierU | 1792 |
SupplierC | $1,642.00 | SupplierT | 1780 |
SupplierD | $1,588.00 | SupplierS | 1768 |
SupplierE | $1,600.00 | SupplierR | 1756 |
SupplierF | $1,612.00 | SupplierQ | 1744 |
SupplierG | $1,624.00 | SupplierP | 1732 |
SupplierH | $1,636.00 | SupplierO | 1720 |
SupplierI | $1,648.00 | SupplierN | 1708 |
SupplierJ | $1,660.00 | SupplierM | 1696 |
SupplierK | $1,672.00 | SupplierL | 1684 |
SupplierL | $1,684.00 | SupplierK | #N/A |
SupplierM | $1,696.00 | SupplierJ | #N/A |
SupplierN | $1,708.00 | SupplierI | #N/A |
SupplierO | $1,720.00 | SupplierC | #N/A |
SupplierP | $1,732.00 | SupplierH | #N/A |
SupplierQ | $1,744.00 | SupplierG | #N/A |
SupplierR | $1,756.00 | SupplierF | #N/A |
SupplierS | $1,768.00 | SupplierE | #N/A |
SupplierT | $1,780.00 | SupplierD | #N/A |
SupplierU | $1,792.00 | SupplierB | #N/A |
SupplierV | $1,804.00 | SupplierA | #N/A |
<tbody>
</tbody>
Thanks!