Forum Discussion
Rahul Verma
Jul 30, 2017Copper Contributor
Need helpin vlookup function
Question as per attachment ,question no . 6
This looks a lot as if you are asking us to do your homework for you. Such questions are not welcome here.
- Yury TokarevSteel Contributor
Hi Rahul
If your Student table is in A1:C8, and the Score table in E1:F5, your formula in C2 would be
=VLOOKUP(B2,$E$2:$F$5,2,1). Note that the last parameter is equal to 1. It is an approximate match, which is essential for the formula to work in your case.
Yury