MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Joyce on February 09, 2001 3:08 PM

In Excel 97, I am trying to populate a cell in one worksheet with a number from a table by using
The problem is that the Journal worksheet does not always contain a matching entry for (B6) so I end up getting the next closest number. How do I get this to return of value of zero when this is the case?

Posted by Dave Hawley on February 09, 2001 8:23 PM

Hi Joyce

try using



OzGrid Business Applications

Posted by Joyce on February 10, 2001 5:45 AM

That was just what I needed.