How to read value from a table

[akscola]

Hi,
I do not know how to introduce a table in excel and also to read value from a table.For example we have two columns A and B and in our dataset the values are according to A format and want to fetch the corresponding value from table.

A(Height) B(Cm)
tooShort 100
short 150
medium 170

[BenjieLop]

Hi,
I do not know how to introduce a table in excel and also to read value from a table.For example we have two columns A and B and in our dataset the values are according to A format and want to fetch the corresponding value from table.

A(Height) B(Cm)
tooShort 100
short 150
medium 170

What about this? For example, enter this formula in Cell D1,

=if(C1="tooShort",100,if(C1="short",150,if(C1="medium",170,"")))

Cell C1 is where you will enter "tooShort","short" or "medium" and if Cell C1 is empty, Cell D1 will also be empty.

... hope this is the formula that you are looking for.

Regards.

[akscola]

Hi,
Thanks for reply.It surly works but the issue is if you have a big table then using IF statement is really difficult (in my case)

[BenjieLop]

Hi,
Thanks for reply.It surly works but the issue is if you have a big table then using IF statement is really difficult (in my case)

I do not know what your actual case is. I only suggested a formula based on the facts that you have provided. I can only go with what data I have.