Forum Discussion
Excel
Hi I have a mark sheet of a set of marks of a group of learners. e.g. Mark 67.8% Sean 34.2 % Jolene 55,8% I want excel to identify a range and convert it in a next column to a number e.g. ma...
Hi,
If you define somewhere in workbook your marks ranges not to hardcode them, like on this mockup
the formula will be
=LOOKUP(E1,$A$1:$A$9,$B$1:$B$9)