# if formula

#### 33sameer33

##### New Member
Dears

Please I need your help to put marks based on the range below using if formula.

 From To Marks 0 5 0 6 10 1 11 15 2 16 20 3 21 25 4 26 30 5 31 35 4 36 40 3 41 45 2 46 50 1 51 55 0

#### Attachments

• 8.3 KB Views: 5

#### ETAF

##### Member
is this too lookup a value and use the table to produce the marks
=INDEX(\$C\$2:\$C\$12,MATCH(F2,\$A\$2:\$A\$12,1))

otherwise not sure what the formula will do
is it to create the table of marks 0 - 5 and 5-0

IF Formula required - dont understand - what the IF will do

whats the expected results

#### Attachments

• 9.3 KB Views: 3

#### 33sameer33

##### New Member
is this too lookup a value and use the table to produce the marks
=INDEX(\$C\$2:\$C\$12,MATCH(F2,\$A\$2:\$A\$12,1))

otherwise not sure what the formula will do
is it to create the table of marks 0 - 5 and 5-0

IF Formula required - dont understand - what the IF will do

whats the expected results
It works many thanks for your kind support

if there are other ideas I need to know more about them

#### bosco_yip

##### Excel Ninja
Or,

In G2, formula copied down:

=LOOKUP(F2,A\$2:C\$12)