How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Yegarboy Your Own Question

Yegarboy
Yegarboy, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 492
Experience:  Expert VBA Programmer.
Type Your Microsoft Office Question Here...
Yegarboy is online now
A new question is answered every 9 seconds

Hi, I am trying to do a Vlookup and the data being reviewed

Customer Question

Hi, I am trying to do a Vlookup and the data being reviewed is 2 columns wide and 500,000+ rows. I keep getting N/A and do not know what to do. I have 17,000 lines to look up. Please help.

Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Yegarboy replied 1 year ago.

yegarboy :

Welcome To Just Answer!

yegarboy :

Just so we are on the same page your data is sorted correct?

yegarboy :

How are you defining the lookup criteria? i.e.. what are you looking up and from where?

Customer :

Hi

yegarboy :

Hey there :)

Customer :

Yes A to Z

yegarboy :

Ok thanks.

yegarboy :

And how are you searching?

Customer :

I am new to vlookup but =vlookup then using the box to enter the data needed

yegarboy :

If you would prefer, you can upload your workbook to me and I can have a look and implement a solution for you.

Customer :

not sure what you mean by how

Customer :

well, I am not sure

yegarboy :

I will break it down for you step by step :)

Customer :

the data contains material I cannot share without permission

Customer :

wish I could

Customer :

thank you for trying to help

yegarboy :

Ok,... Lets say Columns A and B is where your data table is. From A1 to B5000.

yegarboy :

Your welcome :)

Customer :

I have it in c and d

yegarboy :

Ok, what cell are you using to enter in the search data?

Customer :

order numbers in c and status (return, cancel, shipment in d)

yegarboy :

Ok Im with you so far.

Customer :

the file were I am trying to pull in the status is 17K lines

Customer :

with order #'s as well

Customer :

on a different sheet same file

Customer :

it has more data but I need to get the status pulled in, matched up by order #

yegarboy :

Right. So you are trying to pull both the Order Number and Status from a Vlookup? or just the status after you enter the number?

Customer :

orer numbers are in both sheets so status should work fine

Customer :

order excuse me

yegarboy :

Ok, so do you manually enter an Order number to search for?

Customer :

I am not sure what your question is asking sorry

yegarboy :

Thats ok :)

yegarboy :

What I mean...

Customer :

oh I reference the cell

Customer :

by clicking on it

Customer :

if thats what you mean

yegarboy :

How do you lookup the Order number? Is it typed into a cell then looks it up 1 by 1?

Customer :

yes so in the file I am tring to obtain status I have 17K order numbers listed in the furtherest right column.

Customer :

I think so yes

yegarboy :

Ok, so you want to copy the formula down and have it auto fill the status in

Customer :

yes

yegarboy :

Ok so sheet1 is the table and sheet2 has the lookup results?

yegarboy :

Just checking :)

Customer :

nope

yegarboy :

Same sheet?

Customer :

the lookup is the first sheet

Customer :

I had a heck of atime just getting the data on the same sheet

Customer :

does this matter

yegarboy :

I'll bet.

Customer :

let me switch it and see

yegarboy :

It matters how and where the data is. Thats why i am asking so may questions.

Customer :

can you give me a sec

yegarboy :

I sure can

Customer :

I understand, glad you are

yegarboy :

:)

Customer :

bingo

Customer :

still a lot of n/a's but I have some data populating

yegarboy :

Ok

Customer :

I appreciate your help

yegarboy :

Anytime :)

Customer :

even it cost 65$ :-)

yegarboy :

I will also give you a way to make sure your data stays true

yegarboy :

Make sure you lock in the Table reference with the $ signs in your formula

yegarboy :

Like this

Customer :

ok great

yegarboy :

=VLOOKUP(E1,$A$1:$B$10,2,TRUE)

Customer :

k

Customer :

I thought I needed to put false

yegarboy :

The dollar signs make it so when you copy the formula down, the Table address stays the same :)

Customer :

This is what I have

Customer :

=VLOOKUP(L333,'table_data (3)'!C:D,2,FALSE)

Customer :

can you update the formula?

yegarboy :

Actually lol because you use the entire Column there is no need :)

Customer :

ok great

Customer :

can't wait to get this report automated ;-)

yegarboy :

If in the future you want to beef it up let me know :)

yegarboy :

Please dont forget to Rate my help with "Ok" to "Excellent" service :)

Customer :

will do thanks a lot

yegarboy :

Anytime

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional