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 ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

There are some orders(like 100) taken everyday as well as invoiced

Customer Question

There are some orders(like 100) taken everyday as well as invoiced returned(a lots too), not all the orders are delivered on the next day, maybe few or couple days after or even cancelled, I want to know what orders(sheet 1) are converted into invoices and returned(sheet 2).
For example:
"sheet 1"
order taken order taken order taken order taken order taken
20150513 20150514 20150515 20150518 20150519
828542 829536 829513 830631A 830427
829364 829613 830406 831080A 830697
829543 829645 830631 831647A 830883
829546 829990 830637 831675A 831031
829586 829999 830871 831686A 831317
829594 830256 830953 831702A 831538
829619 830630 830994 831711A 831665
829634 830646 831138 831712A 831677
"sheet 2"
returned inv returned inv returned inv returned inv returned inv returned inv returned inv
20150515 20150518 20150519 20150520 20150521 20150525 20150526
830588 831388 832134AA 831928 832549 829417 827580
829537 831108AA 831625 832316 832054 831248 827581
829539 830408AA 832186 831891 832054AA 832525 829210
829554 831488 831940 831687 832148 832608 829473
830175 831571 830621 832231AA 831727AA 832631 829481
830177 830916AA 831651 831902 831803AA 832646 829505
830274 831486 831546 832102 831677AA 832647 829538
830290 831138 831578 831815AA 831984 832658 829816
How to set this formula, I have tried without success.
Thank you very much in advance.
Submitted: 2 years ago.
Category: Programming
Expert:  Jason Jones replied 2 years ago.

If anyone wishes to ask Jason a question directly,
they can do so at the following page:

My name is Jason. I look forward to helping you today.
Please, explain how the spreadsheet is setup, what the values mean, and what you want as an end product.
You may upload an example of the document, if you wish.
Please, be forewarned that the site is not secure:
- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Thank you,
Customer: replied 2 years ago.

Hi Jason

All the contents includes "order taken" and "invoice return are manually keyed in", i want to know what orders are conversed invoices and returned. order numbers are the same as invoice number, for examples: there are 100 orders taken on May 15, and scheduled delivered from 16th, invoices will be returned starts from 17th (not only 17th one day, as some orders may be delivered few day after), any further questions please let me know freely.


Expert:  Jason Jones replied 2 years ago.
I am sorry, but I am having troubles understanding what is needed.
For this reason, I am opting out of the question and allowing another expert the chance to help.
The next expert will see all that is on this page, so there will be no need to repeat anything.
When another expert picks this up, you will be notified by email.
Thank you for your patience.
- Jason
Customer: replied 2 years ago.

more specific i want to insert one column to every day's orders taken (on sheet 1), to show whether the same number of invoices (on sheet 2) are returned or not, i recon formulas like countif or vlookup can do.

Customer: replied 2 years ago.
Relist: Other.
Jason wanted to leave this questions to others.
Expert:  The-PC-Guy replied 2 years ago.
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question

can you provide an example sheet?

please use a site like

to send it to me

after uploading they give you a file ID#

paste that here