vlookup and if

  • Thread starter Thread starter Natalie
  • Start date Start date
N

Natalie

Hi,

I want to put in a formula which says if the VLOOKUP returns a value then
put it in, but if it returns #N/A then put "CLOSED" instead.

Is this possible? I'm sure I've done this before.

Thanks

Natalie
 
Probably not in Access, since VLookup is an Excel function.

In Access you would accomplish this using an expression like:
NZ(DLookup("FieldName","TableOrQueryName","optional_criteria_string"),"Closed")

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top