Page 101 - Finanancial Management_2022
P. 101
How to LOOKUP the data you
want to find in an Excel range
Many options exist to search for A rticles about looking up data in Excel are written all
data in Excel, but what do you do the time. Indeed, several such articles have
appeared in FM magazine.
if the data is in a range? I should know. I wrote them.
Those articles covered numerous ways to find
data in Excel, but there is one common problem I have yet to
By Liam Bastick, FCMA, CGMA explore: How do you look up data over a range?
Let’s find out.
IMAGE BY LUCHSCHEN/ISTOCK Imagine you are marking an exam, scoring candidates’ marks
A sample example
out of 100, which has the following grading system defined.
Any score of 85 or above gains an “A*” grade, a score between
70 and below 85 (84 for simplicity) rates an “A”, a score
between 60 and under 70 scores a “B”, and so on, as shown in
24 I FM MAGAZINE I June 2022 the screenshot “Exam Marks”.
