Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office
This answer was rated:

OK I have a new question I need answered before I can apply

your Macro - I can...
OK I have a new question I need answered before I can apply your Macro - I can attach my workbooks once I see the paperclip option - basically what I need is for one workbook sheet to pull data cells from another workbook sheet and populate several cells. The problem is that I need to combine nested IF statements with a VLOOKUP statement. The IF statement must decide if the student is grade 9, 10, 11 or 12 and then use the student's ID to lookup data cells from the appropriate workbook associated with the student's grade level. So the 1st workbook name is ‘1314 GN Fitness Data Test’ and the worksheet within this workbook is named ‘Cumulative’ this workbook sheet must pull the data from a workbook named ‘GN_14_FD’ and the workshhet within this workbook is named ‘Cumulative’ and the data cells are in a named range called ‘CumData’ which is $A1:$BC700.
The sample workbooks that I can provide are mentioned above – the data sheets are for students in grade 12 so the IF statements will only work for that grade level from what I am providing you with.
I was thinking that the statement I am looking for will look something like:
IFERROR(IF( $B4 = “9”, VLOOKUP($A4,[GN_14_FD]Cumulative!CumData,16,False), IF($B4 = “10”, VLOOKUP($A4,[GN_14_FD]Cumulative!CumData,16,False),
($B4 = “11”, VLOOKUP($A4,[GN_14_FD]Cumulative!CumData,16,False), ($B4 = “12”, VLOOKUP($A4,[GN_14_FD]Cumulative!CumData,16,False),””))
If you can help me with this I will leave another bonus for you.
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 7 minutes by:
10/28/2013
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,048
Experience: 20 years experience providing remote computer support
Verified
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

I can help,

if you cannot find the paperclip

you can use a 3rd party site like

www.wikisend.com

after using that they give you a download link

paste that here.
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Attachment: 2013-10-28_143307_1314_gn_fitness_data_test.xlsx

This is the 1st file


 


Attachment: 2013-10-28_143329_gn_14_fd.xlsx

This is the file that I need to pull data from.


 


The formulas I need will start in cell P4 but you will not see results until you do cells P11 through Y11 because of grade 12.


Thanks

Ok, give me a day or so, I will see if I can get the formulas working for you

thanks
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Do you have any questions or does everything make sense????

i don't at the moment. But if I need more clarification I will ask
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

OK I will wait for your great results!!!!

Thanks

Steve

 

Please send me an e-mail when you have something for me.

will do
Ask Your Own Microsoft Office Question
ok, I am working on several different probjects right now but I haven't forgotten about you.

I do need some further clarification.

what sheet and cells are we pulling data from

and

what sheet and cells do we want the results in

also what is the criteria to determine the results you are looking for other than 9 - 12?
Ask Your Own Microsoft Office Question
did you see my previous response, I had a few questions

what sheet and cells are we pulling data from

and

what sheet and cells do we want the results in

also what is the criteria to determine the results you are looking for other than 9 - 12?
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

I am sorry I never received an e-mail from you so I did not think you responded to my question yet - once I closed this window I did not see any response from you until I reopened this original question.


 


I will try and explain as best I can:


 


The formulas need to be in workbook '1314 GN Fitness Data Test' sheet 'Cumulative' and the 1st cell will be 'P4'. The formula needs to 1st check what grade the student is in (9,10,11,12) then use the VLOOKUP statement to access the proper Data Workbook based on that grade level and pull the data that is in the same corresponding sheet 'Cumulative' and cell 'P4'.


 


The only Data Workbook I sent you was for grade 12 therefore you may want to start with cell 'P11', however the 1st piece of data for that student is in cell 'T9'.


 


So basically the formula needs to do the following: from the 1st workbook (1314 GN Fitness Data Test) check (IF) to see what grade the student is in (9,10,11,12) then use the student ID to lookup his scores in the appropriate Data Workbook (GN_14_FD) within the same named sheet (Cumulative) and the same corresponding cell.


 


I then need to duplicate this formula for all columns P through BC.


 


Let me know if this helps. Hopefully you can get this done somewhat soon as I need this formula in order to proceed with my project.


 


Like I said I never received an e-mail like I have always in the past so I never checked to see that you responded to me.


 


Thanks

i am not sure what is going on with this site, but I have no control over the communications. I just post my replies here.

I think I understand what you are getting at.

I will first check column B, then when I get the grade, use the ID from Column A to do the lookup.

I think I got it.

I need to know the name of each of the workbooks the data is coming from and which number that is associated with

for example the complete file name

name "2013-10-28_143329_gn_14_fd" is the workbook you sent and that is associated with 12.

Remember the file names are XXXXX XXXXX

so GN_14_FD is not the same as gn_14_fd

hope that makes sense.

If I get that information, Then I can program it to work correctly, and you can modifiy the names of the workbooks in the formula as you see fit.
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Thanks for getting back to me - this time i received an e-mail so I knew you responded.


 


The main workbook that receives all the data will now be called:


"1314_GN_Fitness_Results"


 


The Data workbooks and their associated grades are as follows:


 


grade 12 named "GN_14_FD"


grade 11 named "GN_15_FD"


grade 10 named "GN_16_FD"


grade 9 named "GN_17_FD"


 


The main that I sent you did not have the underscore characters, I decided to use underscore characters so all the names are XXXXX XXXXX I hope this makes sense.


 


Thanks again!


Steve


 

here we go

this has the formula in it

http://ge.tt/4xYahcw/v/0?c

if there is a problem with the data not showing up, then it means that the workbook names are XXXXX XXXXX the formula, and not properly linked.

IF this is the case, I will have to remote in and fix it for you to save time.

Let me know
Ask Your Own Microsoft Office Question
hey there,

Just following up.

Are my notifications not going through again?

Are you having any problems?

Are you having issues with rating? Usually you are very good about rating.

let me know thanks
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

I have been very busy and have not tried your formula as of yet but I have time tomorrow to really test everything out and so I will get back to you tomorrow if not tonight.


 


Thanks for checking and yes I am now getting your e-mails.

ok, will wait to hear back from you.

Thanks for letting me know that we got the communications straitened out
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

OK the students for grade 12 are transferring perfectly but the other three grade levels are off by a few columns. I am sure you are aware that the main file "1314 GN Fitness Data Test" is trying to pull data from four different data workbooks using the exact same 40 columns (P through BC). Your formula is pulling the data from all four data workbooks correctly its just that grade levels 9,10, and 11 are not transferring to the appropriate columns in the main workbook.


 


I have attached a WORD document that I hope illustrates this. Please let me know what you think?


Steve


 


 


 


 


Attachment: 2013-10-31_131902_just_answer_question_10_28_13_follow_up.docx


 


 

the best bet would be to remote in and see what is going on.

Let me know when would be a good time to do this
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

OK I have ALL 5 files currently opened in Excel - so what do we do now?

 

I am ready when you are.

 

I copied your formula with and I changed the file names to match my four data workbooks. Please let me know when you are ready as i have some errands to run and do not want to miss your message. I have about another 40 minutes before I have to leave.

 

I have until 9:45 Illinois Time.

 

Thanks

 

Steve

 

OK I have to leave for a while but I will let you know when I am back at my computer. It is now 9:30.

ok, sorry I missed your response.

I will be around any time after noon today EST.

respond when you get back, and Ill help you then
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

I just got back do you have time now or after noon?

afternoon would be the best, XXXXX XXXXX can give you dedicated attention.

say 1PM EST
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

OK sounds good!

speak to you then
Ask Your Own Microsoft Office Question
i am here.

please use the join.me app do you still have it

if not

you can get it form

https://join.me/

click the orange start meeting button

run the app

at the top center of your screen would be a 9 digit code

paste that code here
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

504-708-208

 

540-708-208 sORRY

 

I also had to add another column so now my cells are from Q - BD instead of P - BC I adjusted the formulas accordingly I think.

that is coming back as an invalid code

do you want to double check?
Ask Your Own Microsoft Office Question
Solution provided via Remote
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,048
Experience: 20 years experience providing remote computer support
Verified
The-PC-Guy and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
hi there,

I am still awaiting a rating.

Thanks
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Yes, I know that and you should know by now that I will definitely give you a rating after I have tested everything out. Your latest work in terms of the formula now appears to be working - I had to tweak the grade 12 a little bit but it all seems good now.


 


I have a problem perhaps with your Macro that you gave me the last time - the Macro worked with a drop down list and adjusted every time you used a filter - the problem is every time I try to use a filter even on a different page Excel starts calculating and it takes a few minutes before it hits 100% and I have to wait until it is finished so I have to get that fixed. The exact message on the bottom right of the screen says: 'Calculating (2 processor(s)): __ %.


 


Even when I turn off automatic calculating which I do not want to do it does this every time I save the file.


 


What do you suggest?


 


I have attached the Macro that you sent me - I have changed the sheet names and cells to fit my exact worksheet.


 


Attachment: 2013-11-01_195604_drop_down_list_filtered_macros_new.docx


 

Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,048
2,048 Satisfied Customers
Experience: 20 years experience providing remote computer support

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

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

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 CustomerNew 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!!!!

AlexLos 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.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, 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.

EstherWoodstock, 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.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

694 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,048 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

146 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I am trying to access my NYT account but do not have my
I am trying to access my NYT account but do not have my password..any help appreciatedd … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
694 satisfied customers
I need instructions on how to print labels from excel
I need instructions on how to print labels from excel listing … read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,048 satisfied customers
Two days ago I upgraded to High Sierra and reloaded
Two days ago I upgraded to High Sierra and reloaded Microsoft office. Now I cannot open a document I finished last evening. It's titled "Seoul" and it's a document (DOC) shows on the icon. How do I re… read more
Kris R
Kris R
IT Manager
Computing
2,411 satisfied customers
Having problem signing in not getting code on my e mail got
having problem signing in not getting code on my e mail got a new tower for my computer 2 days ago ? maybe problem am not computer smart sorry i just saw e mail for microsoft is not what i thought … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
518 satisfied customers
Cannot save a document in Word because of "file permission
cannot save a document in Word because of "file permission error" How do I get rid of this so I can save documents? … read more
Cody
Cody
Computer Science
1,540 satisfied customers
My laptop came from the repair-shop, the HD collapsed - (for
My laptop came from the repair-shop, the HD collapsed - (for 2nd time) and "they" returned it without my Microsoft package :( … read more
Cody
Cody
Computer Science
1,540 satisfied customers
Just purchased a new computer and it is telling me that the
just purchased a new computer and it is telling me that the password ***** I input was not correct … read more
Bryan
Bryan
IT Consultant
8,747 satisfied customers
My computer crashed and I ended up restoring to factory
My computer crashed and I ended up restoring to factory settings. I re-installed successully Microsoft office after restoring, but again had computer issues. Once again returned to factory settings. E… read more
Bryan
Bryan
IT Consultant
8,747 satisfied customers
I have a laptop and I want to access the internet,
I have a laptop and I want to access the internet, presumably through Google, but I can't do it. In fact I received an alert from Google indicating someone is trying to access my google account from J… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
694 satisfied customers
I want to combine multiple rows with the same name in column
I want to combine multiple rows with the same name in column 1 into 1 row. Each row has about 35 columns, but within each row name, there will never be entries within the same column. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
My system was upgraded by accident. My problem is that the
My system was upgraded by accident. My problem is that the password ***** I had for my "guest' password ***** not work . My regular password ***** ***** but i do not want to give it out to family. How… read more
Bryan
Bryan
IT Consultant
8,747 satisfied customers
I get messages from microsoft that i have many errors can u
i get messages from microsoft that i have many errors can u help me? … read more
Cody
Cody
Computer Science
1,540 satisfied customers
Have a Access database built in windows 7, need to run and
Have a Access database built in windows 7, need to run and work with it in windows 10? … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I have received two notices that someone has possibly hacked
I have received two notices that someone has possibly hacked into my Microsoft account and it is asking me to recover my account by signing in. Is this legitimate or a scam? … read more
Byron
Byron
IT Support Specialist
Bachelor\u0027s Degree
410 satisfied customers
How can I find out what the top row keys are for? f12 ins
How can I find out what the top row keys are for? f12 ins prt sc … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
My Microsoft Word refuses to shut down: it has been playing
My Microsoft Word refuses to shut down: it has been playing up for days, … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,274 satisfied customers
I forgot my PW to open screen. I have windows 10. Windows
I forgot my PW to open screen. I have windows 10 JA: What application are you using? Customer: Windows 10 JA: Have you installed any updates recently? Customer: no JA: Anything else you want the Micro… read more
Byron
Byron
IT Support Specialist
Bachelor\u0027s Degree
410 satisfied customers
I'[m writing a manuscript and I want the page numbers to
I'[m writing a manuscript and I want the page numbers to begin five pages in. How do I do this? … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
694 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x