Question

Hello , Is there any body available to help me in excel formula ?

Answer 1

Hello, Is there any body available to help me in excel formula ?

Answer 2

What is your question?

Answer 3

Please help me in this regard
I have a problem in excel please assist me.
A Text Range is present in Cell A1 to A20
in front of that a different Text Range is Present in Cell B1 to B20.
and the Text Showing Cell is E5
I want that if the Cell E5 is equal to A1
then the result must be what is present in B1
(in the Target Cell E15) Rest of all results of A2 to A20 exactly like that

I have entered the following formula but it accepts only 8 times not more then that (otherwise it gives an error of FALSE)

=IF(E5=A1,B1,IF(E5=A2,B2,IF(E5=A3,B3,IF(E5=A4,B4,IF(E5=A5,B5,IF(E5=A6,B6,IF(E5=A7,B7,IF(E5=A8,B8))))))))

Please tell me the correct formula of it.

I shall feel great obliged to you. An early reply will highly be appreciated.
Thanking you in advance.
Heyrose

Answer 4

if anybody can help me please help I am very much confused.
if you like pls. send me directly to ID : bakaliimports@yahoo.com

Answer 5

Hello, Dear Friends Please Help me in to enter the right Excel Formula in my sheet. I am very much confused.
if anybody can help me please help I am very much confused.
if you like pls. send me directly to ID : bakaliimports@yahoo.com

Answer 6

perhaps its better to just attach the file

Answer 7

=HLOOKUP(E5,A:B,2,False)

Answer 8

sloory that should be =VLOOKUP(E5,A:B,2,False) and not HLOOKUP