Hi,
i have this table and this formula,
<tbody>
</tbody>
how can modify it that if a/c # is blank still get the amount base on id column #.
thanks,
i have this table and this formula,
Code:
=INDEX(Sheet1!D2:D4,MATCH(Sheet1!C2,Sheet1!C2:C4,0)*MATCH(Sheet1!A2,Sheet1!A2:A4,0))
ID | DESC | A/C # | AMT |
133888 | VOICE | 8883 | 545 |
100300 | IP | 9833 | 800 |
100358 | INTERNET | #N/A |
<tbody>
</tbody>
how can modify it that if a/c # is blank still get the amount base on id column #.
thanks,