Advertisement

07.22.2008 at 03:14AM PDT, ID: 23584584
[x]
Attachment Details

VLOOKUP #N/A Error

Asked by west_ham_66 in Microsoft Excel Spreadsheet Software

Hi guys

I tried using the following =IF(VLOOKUP(MID(A2,3,4),Sheet2!A2:J19,3)="","NOT DONE","DONE "&VLOOKUP(MID(A2,3,4),Sheet2!A2:J19,3)).  However, I get this error #N/A when I use it.  I have traced the error and it appears to be having a problem with the first part of the query (ie the mid).  When I evaluate the formula the mid works correctly, but when I step in the error appears.  Any ideas.Start Free Trial
[+][-]07.22.2008 at 04:09AM PDT, ID: 22057971

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.22.2008 at 04:16AM PDT, ID: 22058033

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.22.2008 at 04:56AM PDT, ID: 22058328

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.22.2008 at 04:59AM PDT, ID: 22058345

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Sign Up Now!
Solution Provided By: Psychotec
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.23.2008 at 02:14AM PDT, ID: 22067304

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 02:39AM PDT, ID: 22067406

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 02:56AM PDT, ID: 22067484

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:01AM PDT, ID: 22067508

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:03AM PDT, ID: 22067516

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628