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: 1517
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: RAQUEL ACION, Dana Friedt, Shawn Barwick, Nada Perovic, Uwe von Gostomski
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Sopi Yuniarti
LAFONSO HERNANDEZ
Forum Stats:
Groups: 3
Forums: 24
Topics: 6218
Posts: 27266
Member Stats:
Guest Posters: 49
Members: 31901
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —