Excel - IF Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

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

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc