comparing columns in excel 2007

[4ukh]

dear experts,

how to compare two different columns to check that whether the values in the cell are same or different using excel 2007...

thanks in advance,

4ukh

[4ukh]

can i use vlookup() with some condition???

[sibisa84]

dear experts,

how to compare two different columns to check that whether the values in the cell are same or different using excel 2007...

thanks in advance,

4ukh

hi,

u can use this function

A1 B1 =EXACT(A1,B1)

Chennai Chennai TRUE
Chennai Chenna FALSE

Regards By SiBiSa

[4ukh]

please share =vlookup()

4ukh

[lindarothrock]

dear experts,

how to compare two different columns to check that whether the values in the cell are same or different using excel 2007...

thanks in advance,

4ukh

Try to use the formula bar in excel to compare the values in a cell. You can type =a1(first value)=a2(second value) then press enter. If excel shows it's true then they are of the same value otherwise, they do have different values.

cohiba cigars

[4ukh]

Try to use the formula bar in excel to compare the values in a cell. You can type =a1(first value)=a2(second value) then press enter. If excel shows it's true then they are of the same value otherwise, they do have different values.

cohiba cigars

thank you but that doesn't work for me actually i need to find the value of the cell/cells of a column where given criteria match like:

column A, B and C contains some values and there is an outer sheet but in this case case same sheet but different columns like G,H and I where "I" is empty yet waiting for the information from the column "C" where column A and B match the columns G and H respectively.

simply speaking i want to grab the data form a cell where conditions match.

please help

thank you guys

regards

4ukh

[4ukh]

I'm very familiar with the Vlookup function.
The problem is that function only search for ONE parameter and return whatever columns on the same row when parameter is found.
I want to look for four (4) different parameters in 4 different columns and return a different columns on the same row when all 4 parameters matches.
How can I do that?????

4ukh