Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles Miscellaneous Issue response time calculation

Issue response time calculation

If you need to calculate a response time based on priority level, you can create a table with status and apply VLOOKUP. This tutorial will show you how to issue response time calculation with a detailed example.

Formula

=Xn+VLOOKUP(value, table, column, FALSE)

Explanation

In this formula, Xn represents any cell that can be A1, B3 or any other in the Excel sheet.

VLOOKUP function accepts four arguments here.

  • The first argument is the value that is to be searched for in the vertical column passed in 2nd argument.
  • After the entry is found in the vertical table, 3rd argument defines the index of the column from which the entry is to be returned as a result.
  • The last argument is FALSE, which makes it able to find the exact match from the lookup table

Example 

Firstly, we will go through a sample that time has been considered each with its specific priority level. The maximum response time is specified separately for each priority level from 1 to 5.

Figure1. Sample sheet for calculating and issuing the response time

Calculating the response time in cell B3, with the priority level in C3, VLOOKUP searches for the priority level in the array F3 to G7  and corresponding response time is added to it. Enter the following formula in cell D3.

=B3+VLOOKUP(C3,F3:G7,2,FALSE)

Figure2. Entering the formula in D3 to calculate the response time

Finally, the result shows the priority set for each entry as below:

Figure3. Issuing the calculated response time

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
I have a pivot table in which per order (on the rows) stands how much products they ordered per size (on the columns). I want to determine which combinations of quantities of sizes people order. And I want to count these combinations.
Solved by E. W. in 60 mins
I have 500 numbers in column A with aproximatly 15digits. In column B I have 5 numbers with 6 digits Can a find a formula wich can transfer all numbers from A column wich start with some 6 digitsa from B column
Solved by V. L. in 32 mins
I filtered data in column A (it is labeled ID #) of a data set. On my next worksheet, column A is also the ID #, but it is a different data set. I want to filter the ID #'s the same for the two sheets, but how do I do that being that I am working with two different sets of data?
Solved by V. H. in 22 mins
I have a sheet with 3 columns. First column is a code for records in column B (has 563 records). What I need is a formula to show me if what is in column C (has 4400 records) is in column B and if it is to take the code for that record. Example: Column A(code corresponding to column B): 12, 14, 15, 19 Column B(names): asd, adf, ade, aqw Column C(names): akd, adf, ade, anb, wgs I need something that would say, if record in column C (for example adf) is matching record in column B (adf) return the code from column A (the code corresponding to that record in column B),if not return blank.
Solved by C. J. in 8 mins
If the data in A matches the data in C, then I need the data in E to be placed in B
Solved by X. W. in 40 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc