Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
13
Views
Topic starter
Please help me with these 2 vlook up related questions. I have attempted to solve the questions but failed. Any help will be highly appreciated.
Posted : 18/05/2020 6:57 am
Hi Fahad,
The first qs requires you to work out the average score for undergraduates and then look that value up. To work out the average score for undergrads you can use AVERAGEIFS
Then use VLOOKUP to lookup the value using an approximate match.
The 2nd qs just needs you to do exactly as it says. Enter a formula into D2 then copy it down to D10. However I think as it's written in your workbook it is not correct. I think the range I3:J13 needs to be absolute references i.e. $I$3:$J$13.
See attached.
Regards
Phil
Posted : 18/05/2020 8:03 am