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
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
44910485
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I need to match 1 column with another sheet, if that

Customer Question

I need to match 1 column with another sheet, if that matches, i need to match another column with another sheet, if that matches, i need to match another column with another sheet, then pull in the difference in quantities from both sheets
Submitted: 1 month ago.
Category: Programming
Expert:  George Sibiya replied 1 month ago.

Hi,

Welcome to JustAnswer and thank you for utilising our service.

I am reviewing your question and will post back shortly.

Regards,

G

Expert:  George Sibiya replied 1 month ago.

Hi,

Just so that I understand your question better:

1. On how many sheets to you want to do the matching?

2. Which example column on which sheet would you like to match against which sheet?

Regards,

G

Customer: replied 1 month ago.
1 sheet. if column a = column a in the second sheet, look for column b = column b in the second sheet, look for column c = column c in other sheet. if all match return the number in second sheet if they don't match return what isn't matching
Customer: replied 1 month ago.
sheet 1 needs to look at sheet 2
Expert:  George Sibiya replied 1 month ago.

Thank you so much for the info and the attachment. I am on it and post back shortly once done.

Customer: replied 1 month ago.
I never heard back on this, did you have an opportunity to work on it?
Expert:  George Sibiya replied 1 month ago.

My humble apologies I fell asleep late last night while on it I am only back on it now after work. You can expect it in the next three hours.

Expert:  George Sibiya replied 1 month ago.

I'm still here, just a moment.

Expert:  George Sibiya replied 1 month ago.

Hi,

Please read the comment on Sheet1 F1 and post your response here or on the document itself and attach it.

Regards,

G

Expert:  George Sibiya replied 1 month ago.

Please check the attached and advice if its what you require and also otherwise.

Customer: replied 1 month ago.
I cannot open the attachment
Expert:  George Sibiya replied 1 month ago.

Ok. I'll rework something on it and use other means to upload it

Expert:  George Sibiya replied 1 month ago.

Hi,

I think I must not waste more of your time.

G

Expert:  Bruce Wilner replied 1 month ago.

Howdy. Perhaps I can help with this. I see you are still having some issues.

Do me two favors:

(a) explain PRECISELY the calculation that you want.

(b) post a spreadsheet in XLS (NOT XLSX) format.

Thank you for your anticipated cooperation. We should be able to solve this very quickly.

Customer: replied 1 month ago.
I've figured it out on my own
Expert:  Bruce Wilner replied 1 month ago.

I'm, delighted to hear that. Not expressing the requirement clearly to others is a surefire way to guarantee that they don't figure it out! However, by the same token, I'm concerned that you may have ended up solving a problem that is not quite the problem you set out to solve. The solution to any problem begins with a crystal-clear understanding (= statement in black and white) of what that problem is!

Refunds can be obtained--no questions asked (well, hardly any)--from customer service, +1(###) ###-####/strong>.