Recent content by brent_s

Interesting observation. I was using the #N/A to let me know the VLOOKUP failed to find a name match and then provide the appropriate response. After looking over your code, I realized I was using MATCH incorrectly. I was trying to do what you did with the "does not equal" operator. After...

In the original formula, the first thing I did was test for #N/A. If that was the case I didn't need to go beyond the test for OOB. Your suggested rewrite eliminates that. I'll need some time to evaluate the changes and get back to you. Need to leave for awhile so it will be 3 or more hours. I'm...

OK, here's the logic: Do the names NOT match (produce an error)? Yes--Does D = OOB Yes --enter "OOB" No--enter "Moved" No--Does the Apt NOT start with D or C-3 Yes--enter "Wrong Bldg/Flr" No--Do the Apts in D & E NOT match...

Thanks NBVC for your response and willingness to help me with this issue. Yes, the letter C- is part of the number and has no space between the letter, dash, and number. I use VLOOKUP to match names from another worksheet to populate column E with the relevant data. The IF function, using MATCH...

I would like to use the MATCH function to compare two columns of data and alert me when there is a disparity. I get mixed results. Some rows function as expected, others fail to catch the error. In testing, I purposely change the data in column D so it doesn't match E expecting to get an error...

Hi, I am a moderately experienced user of Access. Have built several databases over the course of 19 years that incorporate switchboards, queries, forms, and reports, but rely on built-in functions rather than VBA (never needed to learn it). I'm aware that imbedded VBA procedures are run when...