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
