Microsoft Office Questions? Ask a IT Expert for Support ASAP
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.
Welcome To Just Answer!
Just so we are on the same page your data is sorted correct?
How are you defining the lookup criteria? i.e.. what are you looking up and from where?
Hey there :)
Yes A to Z
And how are you searching?
I am new to vlookup but =vlookup then using the box to enter the data needed
If you would prefer, you can upload your workbook to me and I can have a look and implement a solution for you.
not sure what you mean by how
well, I am not sure
I will break it down for you step by step :)
the data contains material I cannot share without permission
wish I could
thank you for trying to help
Ok,... Lets say Columns A and B is where your data table is. From A1 to B5000.
Your welcome :)
I have it in c and d
Ok, what cell are you using to enter in the search data?
order numbers in c and status (return, cancel, shipment in d)
Ok Im with you so far.
the file were I am trying to pull in the status is 17K lines
with order #'s as well
on a different sheet same file
it has more data but I need to get the status pulled in, matched up by order #
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?
orer numbers are in both sheets so status should work fine
order excuse me
Ok, so do you manually enter an Order number to search for?
I am not sure what your question is asking sorry
Thats ok :)
What I mean...
oh I reference the cell
by clicking on it
if thats what you mean
How do you lookup the Order number? Is it typed into a cell then looks it up 1 by 1?
yes so in the file I am tring to obtain status I have 17K order numbers listed in the furtherest right column.
I think so yes
Ok, so you want to copy the formula down and have it auto fill the status in
Ok so sheet1 is the table and sheet2 has the lookup results?
Just checking :)
the lookup is the first sheet
I had a heck of atime just getting the data on the same sheet
does this matter
let me switch it and see
It matters how and where the data is. Thats why i am asking so may questions.
can you give me a sec
I sure can
I understand, glad you are
still a lot of n/a's but I have some data populating
I appreciate your help
even it cost 65$ :-)
I will also give you a way to make sure your data stays true
Make sure you lock in the Table reference with the $ signs in your formula
I thought I needed to put false
The dollar signs make it so when you copy the formula down, the Table address stays the same :)
This is what I have
can you update the formula?
Actually lol because you use the entire Column there is no need :)
can't wait to get this report automated ;-)
If in the future you want to beef it up let me know :)
Please dont forget to Rate my help with "Ok" to "Excellent" service :)
will do thanks a lot