vlookup and if

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
 
J

John Spencer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF and Vlookup 3
Newbie Help - IF Yes No Function 0
Vlookup returns #N/A when Range is 'false', but returns values when 'true' 4
Multiple IF Statement 2
Can I add a formula or function to Vlookup? 1
Replacing a phrase with carriage returns 1
VLOOKUP returning #N/A ?? 3
Display weeks from a Milestone 0

Top