Question description:
This user has given permission to use the problem statement for this
blog.
In cell E2, enter a formula using the HLOOKUP function to determine a staff memberâ??s base salary (which is based on the number of years of service).
Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since base salary is tiered based on the number of years of service, find an approximate match.
Fill the formula into the range E3:E31, if necessary.
Solved by G. W. in 53 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/10/2018 - 04:28
Hello, I understand that you need help with HLOOKUP, right?
Excelchat Expert
09/10/2018 - 04:31
Are you there?
Excelchat Expert
09/10/2018 - 04:31
If you can read this but are unable to reply please try to refresh your browser.
Excelchat Expert
09/10/2018 - 04:32
Otherwise, you can try to send a message using the sheet to the right.
Excelchat Expert
09/10/2018 - 04:33
If those don't work, your network may be partially blocking our platform and if that's the case I'd have to ask you to please contact our support team so they can help you with the connectivity. Meanwhile I'll be solving your problem based on the information and the sheet you provided.
Excelchat Expert
09/10/2018 - 04:33
sheets.support@gotitapp.co
Excelchat Expert
09/10/2018 - 04:33
Hopefully this session will still be rated fairly as there's really nothing I can do about the network blockage.
Excelchat Expert
09/10/2018 - 04:37
I tried to recreate your file based on your description and this is the formula that I came up with:
Excelchat Expert
09/10/2018 - 04:38
=hlookup(D2,$Q$15:$U$16,2,1)
Excelchat Expert
09/10/2018 - 04:38
This will compare the service years of a staff member in column D to the Service Years in the table found at $Q$15:$U$16 which holds the salary depending on the years.
Excelchat Expert
09/10/2018 - 04:39
It will then return the salary found in the row 16 of Q:U
Excelchat Expert
09/10/2018 - 04:39
This will be using approximate match as mentioned in the instructions.
Excelchat Expert
09/10/2018 - 04:39
The 1 at the end of the formula will make it so.
Excelchat Expert
09/10/2018 - 04:40
Since you were not able to upload your file, please download this instead:
Excelchat Expert
09/10/2018 - 04:40
[Uploaded an Excel file]
Excelchat Expert
09/10/2018 - 04:40
I will be staying a while to give you enough time to try and communicate with us.
Excelchat Expert
09/10/2018 - 04:41
Hopefully this session will still be rated fairly as there's really nothing I can do about the network blockage and we were still able to provide a solution based on the instructions you left.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.