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
Hope, the explanation is helpful.
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
Have a great day ahead.
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.