Previous Topic Next Topic

Conditioanal Argument

Closed
Vish - Jul 28, 2009 at 05:37 AM
 Trowa - Jul 28, 2009 at 08:04 AM
Hello,
I have data in A col, B col, and C col I want compare data in A1 with Data in B col if it is matching, It has to display the data which is available in C Col. I used multiple command but I could not get proper out put. Example has been given below
A B C

Cot Chair I Floor
bed TV Stand Ground Floor
bedsheet Bed II Floor
Cot III Floor
Bedsheet IV Floor
Now Cot in Col A1 matches to Cot in Col B4, It has to display III Floor in another cell

Can some body help me in sorting out this please

2 responses

Answer 1 / 2
Trowa
Jul 28, 2009 at 07:06 AM
Hi Vish,

The function you are looking for is called V.LookUp.

Your example looks incomplete:

A1:A5 = Cot, Bed, Bedsheet, "", "". (A4 and A5 are empty??)
B1:B5 = Chair, TV Stand, Bed, Cot, Bedsheet.
C1:C5 = I Floor, Ground Floor, II Floor, III Floor, IV Floor.

Anyway the formula in this case looks like this (use D1 for example):
=v.looup(A1;$B$1:$C$5;2)

You can also drag this formula down.

If you get an error use a "," instead of a ";" depending on your excel version.

Please post feedback.

Best regards,
Trowa
0
vishuhk Posts 3 Registration date Monday July 27, 2009 Status Member Last seen July 30, 2009
Jul 28, 2009 at 07:54 AM
Thnaks a lot thrva for quick response but it is not giving the result in c col. In all the cells it is mentioning II Floor. Please help me in solving this.
0
Answer 2 / 2
Trowa
Jul 28, 2009 at 08:04 AM
Hi Vishuhk,

It's probably because your cells are made up differently.

Can you give a clearer example of how your sheet looks like.

Maybe you can upload you file without any personal information using the following link:

https://authentification.site

Waiting for your reply,
Trowa
0