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 Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 6116
Experience:  Computer Software Support specialist for more that 10 years
49766785
Type Your Software Question Here...
Jess M. is online now
A new question is answered every 9 seconds

Need help with excel & google sheets index match formula.

Customer Question

Need help with excel & google sheets index match formula.
Submitted: 3 months ago.
Category: Software
Expert:  Jess M. replied 3 months ago.

Hi Jo, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

Can you please send me a sample of your Excel file so that I can check and help you? You can attach the sample Excel file here when you reply or upload it to http://filesXpress.com and then give me the short download link.

Please let me know by replying to me here so that I can help you further.

Best regards,
Jess

Customer: replied 3 months ago.

I just sent the short link to an excel workbook.

Customer: replied 3 months ago.

I just sent the short link to an excel workbook.

I need to get the unique numbers from column H and bring back the data for those numbers from columns K-S.

Expert:  Jess M. replied 3 months ago.

Thank you for writing back. Is it the file named Bab New Mail?

Customer: replied 3 months ago.

Yes ... sorry I meant to advise that...

Expert:  Jess M. replied 3 months ago.

You want to list the UNIQUE numbers in H (no duplicates) and then pull out their corresponding data from K through S. Is that correct? If yes, where do you intend to put this list? In a new sheet?

Customer: replied 3 months ago.

a new sheet or next to the list of unique numbers is fine too...

Expert:  Jess M. replied 3 months ago.

And do you want it to be dynamic? Like when your initial data in H is from H2:H200, but the formula will still work when you modify the data or append to it like up to H2000?

Customer: replied 3 months ago.

not sure what you mean..

My intention is to generate a report...like a database query.

The report will match the transaction ID & return the data in other columns for that number.

Such as a report for a mail list.

Expert:  Jess M. replied 3 months ago.

Yes, I understand. But are you planning to do this per transaction ID? Like, you will enter one ID and then when it matches, relevant data will be shown? Or do you want this report to automatically display based on the original sheet that you have? I believe you want the later.

Customer: replied 3 months ago.

Well, I think that knowing both would be very helpful.

Normally, the use is to take a list of Trans_ID numbers to draw back specific cells of data from specific column(s) associated with the Trans_ID on the row.

However, a similar formula that would pull back an auto report for an updated mailing list, for instance, would be very useful as well.

Expert:  Jess M. replied 3 months ago.

Ok. I will try to do both on separate sheets. Please give me a moment.

Customer: replied 3 months ago.

Of course... Thanks ! Smile

Expert:  Jess M. replied 3 months ago.

Thank you. I'm almost done with the individual ID option

Expert:  Jess M. replied 3 months ago.

Hi Jo,

Here is the initial file:

http://filesxpress.com/d-30134a25

That file has the individual lookup option. I am building the automated report but it can take some time.

Best regards,

Jess