| | |
| |||||||
| Forums | Register | Groups | Awards | Arcade | Pets | T-Bucks / T-Store | Invite Your Friends | Blogs | Mark Forums Read |
| Microsoft Applications Discussions about Windows and other MS Products such as Office |
 |
| | LinkBack | Thread Tools |
08-02-2004, 05:15
| #1 (permalink) |
| Civilians |  I want Cell to remain blank Thanks to Frank Kabel, I have the formula below which works a treat. However, I would like Cell D11 to remain blank, rather than display #N/A, when no value appears in Cells B11 or C11. Cell D11: =INDEX(Rates!$B$2:$J$21,MATCH($C11,Rates!$A$2:$A$2 1,0),MATCH($B11,Rates!$B$2:$J$2,0)) Any ideas? -- Thanks in advance Lee |
     |
| Trackpads Information |
| |
|
08-02-2004, 05:15
| #2 (permalink) |
| Civilians | Re: I want Cell to remain blank Hi see your other thread. Hear the adaption for your cell ranges =IF(COUNTA(B11:C11)=2,INDEX(Rates!$B$2:$J$21,MATCH ($C11,Rates!$A$2:$A$2 1,0),MATCH($B11,Rates!$B$2:$J$2,0)),"") P.S.: please stay in the original thread -- Regards Frank Kabel Frankfurt, Germany Lee Kelly wrote: > Thanks to Frank Kabel, I have the formula below which works a treat. > However, I would like Cell D11 to remain blank, rather than display > #N/A, when no value appears in Cells B11 or C11. > > Cell D11: > > =INDEX(Rates!$B$2:$J$21,MATCH($C11,Rates!$A$2:$A$2 1,0),MATCH($B11,Rates !$B$2:$J$2,0)) > > Any ideas? |
| |
|
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Blank Cell vs Cell equal to Zero (0) | LavaDude | Microsoft Applications | 4 | 09-10-2005 00:00 |
| Get first blank cell | Andrew Clark | Microsoft Applications | 7 | 01-29-2005 20:00 |
| [News Feed] Airborne Cell-Phone Ban Likely to Remain for Now | Forum Mouse | News Articles | 0 | 12-13-2004 04:00 |
| represent blank cell | maluguitarist | Microsoft Applications | 1 | 10-25-2004 20:00 |
| represent blank cell | maluguitarist | Microsoft Applications | 1 | 10-25-2004 20:00 |
 |  |  |
