Using if statement many times!

[Jamal NUMAN]

Using if statement many times!

I’ve two Cells, A1 and B1. I wanted value of B1 to take a value based on the value of A1 in accordance with the table below:

Item

Kg/m2

House

250

Offices

300

Garage

600

Holes

600

Stores

1,000

Commercial

500

For example, if the A1 takes the “Stores” value then B1 takes the “1000”. To accomplish this, I constructed the If statement below and worked very well:

=IF(O2=B3,C3,IF(O2=B4,C4,IF(O2=B5,C5, IF(O2=B6, C6, IF(O2=B7, C7, IF(O2=B8, C8))))))

My point is:

What if we have long table that may contain 100 rows?

Is the “If Statement” practical to perform this kind of work?

Is there other command to help this issue?

Thank you in advance,

Regards

Jamal