MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Lookup


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
=LOOKUP((B6),Journal!A:A,Journal!E:E)
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

=IF(ISNA(VLOOKUP(B6,Journal!A:E,5,FALSE)),0,VLOOKUP(B6,Journal!A:E,5,FALSE))

Instead.

OzGrid Business Applications

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

That was just what I needed.

Joyce