Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

In cells F6:F13, add a VLOOKUP function that returns the raise recommendationâ??High, Standard, or Lowâ??for each employee by exactly matching the Name in column A in the range you named Evaluations. Be sure to use exact match criteria. In cells G6:G13, add a VLOOKUP function that returns the starting raise percentage based on the ranges in the Standard Raise table in cells A16:B19 and the number of years employed in column E.
Solved by X. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/09/2018 - 08:50
Hi,
Excelchat Expert 12/09/2018 - 08:50
Welcome to Excel Chat.
User 12/09/2018 - 08:50
Hi
Excelchat Expert 12/09/2018 - 08:50
You want to know applying vlookup formula? Please share the file.
User 12/09/2018 - 08:51
I have shared the file
Excelchat Expert 12/09/2018 - 08:52
Thanks for sharing the details.
Excelchat Expert 12/09/2018 - 08:53
Upon reviewing further, I need further information as in description: High, Standard, or Low—for each employee by exactly matching the Name in column A in the range you named Evaluations.
User 12/09/2018 - 08:54
Done
User 12/09/2018 - 08:54
Its below
Excelchat Expert 12/09/2018 - 08:54
Ok. Thanks for sharing.
Excelchat Expert 12/09/2018 - 08:54
You wanted to updated Raise Recommeded and Standard rise%
User 12/09/2018 - 08:55
yes
Excelchat Expert 12/09/2018 - 08:55
Ok. Thanks for confirming. I am working on these 2 using vlookup formula.
User 12/09/2018 - 08:55
ok sure
Excelchat Expert 12/09/2018 - 08:57
Please refer the formulas in F2 and G2.
Excelchat Expert 12/09/2018 - 08:58
In F2, I have used vlookup formula with false condition as it is exact match.
Excelchat Expert 12/09/2018 - 08:59
Whereas in G2 cell, i have used True condition as it is approximate match. The Years employed mentioned in the first table are not exactly matching with the second table. Hence, it is considered as approx. match.
User 12/09/2018 - 08:59
yup I noticed that
User 12/09/2018 - 08:59
but I hv a question art F2
User 12/09/2018 - 08:59
what is the formula behind of the A2?
User 12/09/2018 - 09:00
for the VLOOKUP
Excelchat Expert 12/09/2018 - 09:00
I will explain the vlookup formula.
User 12/09/2018 - 09:00
okay sure
Excelchat Expert 12/09/2018 - 09:00
=vlookup(search text, search range, output column in the search range, true / false)
Excelchat Expert 12/09/2018 - 09:00
A2 is search text
Excelchat Expert 12/09/2018 - 09:01
\$A\$20:\$J\$27: Search range.
User 12/09/2018 - 09:01
how do I insert that ?
Excelchat Expert 12/09/2018 - 09:01
Search text must be searched in the first column of search range.
Excelchat Expert 12/09/2018 - 09:02
And you need the result in column J. So, i have considered till column J.
Excelchat Expert 12/09/2018 - 09:02
I have used "\$" symbols to fix the range, while dragging the formula downwards.
Excelchat Expert 12/09/2018 - 09:02
10 is the 10th column in the search range from column A.
Excelchat Expert 12/09/2018 - 09:03
False: Exact match representation.
Excelchat Expert 12/09/2018 - 09:03
For inserting range, you have to select the cells from A20 to J27 and then press F4.
Excelchat Expert 12/09/2018 - 09:03
You will get the "\$" automatically, or you can manaully insert them.
Excelchat Expert 12/09/2018 - 09:04
If you observe formula for F3, you can see the same range, as the search range does not change for row 2 and row 3.
Excelchat Expert 12/09/2018 - 09:04
User 12/09/2018 - 09:07
okay I will go through your explanation again
User 12/09/2018 - 09:07
thank you so much for your help
Excelchat Expert 12/09/2018 - 09:08
Ok. Sure. If you have any further requirements, Please visit Got IT Pro.
Excelchat Expert 12/09/2018 - 09:08
Excelchat Expert 12/09/2018 - 09:08
Please leave great feedback. Thank you.

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.