Log In
Register
Home
Need help on Vlookup problem
fahad feroz
New Member
Members
Forum Posts: 1
Member Since:
May 17, 2020
May 17, 2020
Offline1
May 17, 2020 - 8:57 pm
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.
Philip Treacy
Admin
Forum Posts: 1548
Member Since:
October 5, 2010
October 5, 2010
Offline2
May 17, 2020 - 10:03 pm
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Nicholas Meyer, Manjula Mangalmurti, Cindy Walawander, tre lewis, Earl Tuckman, Rob Starren, Leigh Thomas
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Mohamed Touahria
Sheila McCall
Nicholas Montano
John Babcock
QSolutions Group
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28549
Member Stats:
Guest Posters: 49
Members: 32803
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —