Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a difficult formula using an INDEX MATCH part of it…

Customer Question
I have a difficult...

I have a difficult formula using an INDEX MATCH part of it is working but I need an additional parameter I also have 2 other questions I need an expert please

Technician's Assistant: Is there a specific language you're coding in?

Yes Excel 2016 formulas

Technician's Assistant: When did you last update Excel?

I am using Excel 2016 not sure of the last update

Technician's Assistant: Anything else you want the Software Expert to know before I connect you?

I also have a dynamic data validation list and a similar formula question

Submitted: 7 months ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 12 minutes by:
12/6/2017
Programmer: Kris R, Computer Hardware Engineer replied 7 months ago
Kris R
Kris R, Computer Hardware Engineer
Category: Programming
Satisfied Customers: 4,548
Experience: IT Manager at Wood Group PSN
Verified

Hi
Sorry for the delay, we are busy and I've just got to your question.
How long has this been happening?
Thanks
Kris

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask ATLPROG Your Own Question
ATLPROG
ATLPROG
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7,677
7,677 Satisfied Customers
Experience: MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

ATLPROG 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:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I have a sheet with 2 columns: various different names and a
I have a sheet with 2 columns: various different names and a column with 1 of 6 different IDs. I want to create a Data Validation on another page that lists ONLY the names of each of the 6 different I… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
My index match formulas will not sort with the rest of my
My index match formulas will not sort with the rest of my data. I have $ signs around cell range also in the formula. Why wont it lock at sort with the rest of my fields?… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
I have a super simple vlookup, but I keep getting a value as
I have a super simple vlookup, but I keep getting a value as an answer. I need to match people's first and Last name (contained in columns G and H. This should be matched to the information in A,B,C. … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
Were currently using Crystal Reports with Stored Procedures
We're currently using Crystal Reports with Stored Procedures (SP). We are attempting to pass multi-part parameters into the SP (to be used in an in statement in the where clause). BUT wish to present … read more
Chris Baxter
Chris Baxter
28 satisfied customers
Hello. Attempting to write a line or macro in Excel 2007 that
Hello. Attempting to write a line or macro in Excel 2007 that will identify new columns of product that have been added onto spreadsheet A. Do this by comparing column head text on spreadsheet A to co… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a formula VLOOKUP(E8,Duration_Matrix,MATCH(D8,Unit_Operation)),
I have a formula =VLOOKUP(E8,Duration_Matrix,MATCH(D8,Unit_Operation)), that is working in some cells but not others and need a calculation that returns a value based on a combination of two data poin… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have 2 tables. One table (Table 1)lists a manufacturers part
I have 2 tables. One table (Table 1)lists a manufacturers part number in column "a" and our corresponding part number in column "b". The other table (Table 2)is from the manufacturer and it only lists… read more
unvadim
unvadim
Computer Software Engineer
Diplom
1,168 satisfied customers
Your first procedure is to be named MOVIE_RENTAL_SP and is
Your first procedure is to be named MOVIE_RENTAL_SP and is going to provide functionality to process movie rentals. Based on data that will represent the movie id, member id and payment method your pr… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,175 satisfied customers
I have 2 spreadsheets; One with 37,000 emails and physical
I have 2 spreadsheets; One with 37,000 emails and physical addresses and another with 5,000 'chosen' email addresses. I need to find all 5,000 email adds from my list of 37,000 and make sure their phy… read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
I have an Excel spread sheet with two pages sheet1 & Sheet2 On
I have an Excel spread sheet with two pages sheet1 & Sheet2 On sheet 1 in cell A1 in sheet1 I want to reference if it matches any item in column A on sheet 2. If it does I want to insert a reference o… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am currently trying to program an Excel Spreadsheet that
I am currently trying to program an Excel Spreadsheet that will take Employee Performance Data from one Master Sheet that I copy in, and transfer it to multiple sheets that I have made that only take … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need an Excel formula that will select, for each employee
I need an Excel formula that will select, for each employee in a list, their next year hourly rate based on their Job Class and current year rate. Table 1 - 2010 Hourly Rate Schedule Job Class Minimum… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have 2 excel files. I would like to create a 3rd file or
I have 2 excel files. I would like to create a 3rd file or row or whatever of all of the duplicates that appear in excel file 1 and are also in excel file 2. I don't care if they are duplicates in exc… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,130 satisfied customers
I need a formula for a field in an Excel worksheet. The field
I need a formula for a field in an Excel worksheet. The field returns the Federal Tax applicable for an earnings amount field. The tax sheet has 5 fields (at least; not more than; 0; 1; 2). The formul… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
i need to do a v look up between two files, both files contain
i need to do a v look up between two files, both files contain a id cell & a last name cell, the second file also contains a first name cell......I need to bring the first name cell into my first exce… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Dear Expert, Often I need to merge two data tables in Excel,
Dear Expert, Often I need to merge two data tables in Excel, which have only one column sort off in common, and even that - with non-unique entries. Can a marco be built that will allow me to do this?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
1.What tasks are normally done as part of database maintenance
1.What tasks are normally done as part of database maintenance? Why are they important? 2. How might maintenance tasks be expected to change over time? What sorts of tasks might be required soon after… read more
Emma2009
Emma2009
Systems Engineer
Bachelor's Degree
20 satisfied customers
I need to compare selected rows of data from worksheets in
I need to compare selected rows of data from worksheets in two different workbooks (master & Slave) using selected data/cells within the workbooks and updateting a selected cell in the slave worksheet… read more
John D
John D
Bachelor Degree in Engineering
342 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