Comparing Information in 2 columns
 

I need to know how to compare a cell address in one column and find if that
cell location is in another column.

I thought that i would use the if function and my formula was
=if(e1=n4:n300,true,false) but this does not seem to work any help would be
appreciated.

Comparing Information in 2 columns
 

cell location/addesses can not change, nor can they be equal. (A2 is an
address, there is no way another cell can be on same sheet, and same address!)

If you want to know if the value of one cell is present in a column:
=IF(OR(N4:N300=E1),TRUE,FALSE)
confirmed as an array formula (Ctrl+Shift+Enter) will work.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tabatha" wrote:

I need to know how to compare a cell address in one column and find if that
cell location is in another column.

I thought that i would use the if function and my formula was
=if(e1=n4:n300,true,false) but this does not seem to work any help would be
appreciated.

Comparing Information in 2 columns
 

I have this formula in column N
=ADDRESS(MATCH(M4,D$2:$D$981,0)+ROW(D2)-1,COLUMN(D2),4)

Then I have this formula in column e =ADDRESS(ROW(D2)-1,COLUMN(D2),4)

I want to do a formula that will let me know if the cell in Column E is
matched in Column N. Is this Possible? That is what I was trying to use the
find function for.

"Luke M" wrote:

cell location/addesses can not change, nor can they be equal. (A2 is an
address, there is no way another cell can be on same sheet, and same address!)

If you want to know if the value of one cell is present in a column:
=IF(OR(N4:N300=E1),TRUE,FALSE)
confirmed as an array formula (Ctrl+Shift+Enter) will work.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tabatha" wrote:

I need to know how to compare a cell address in one column and find if that
cell location is in another column.

I thought that i would use the if function and my formula was
=if(e1=n4:n300,true,false) but this does not seem to work any help would be
appreciated.

Comparing Information in 2 columns
 

The formlula I posted earlier should work if you're trying to compare a
single cell to an array of cells. (sorta sounds like what you're doing).

Actually, a better, non-array formula is:
=ISNUMBER(MATCH(E1,N4:N300,0))

If E1's value is found anywhere in N4:N300, formula returns TRUE, else FALSE.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tabatha" wrote:

I have this formula in column N
=ADDRESS(MATCH(M4,D$2:$D$981,0)+ROW(D2)-1,COLUMN(D2),4)

Then I have this formula in column e =ADDRESS(ROW(D2)-1,COLUMN(D2),4)

I want to do a formula that will let me know if the cell in Column E is
matched in Column N. Is this Possible? That is what I was trying to use the
find function for.

"Luke M" wrote:

cell location/addesses can not change, nor can they be equal. (A2 is an
address, there is no way another cell can be on same sheet, and same address!)

If you want to know if the value of one cell is present in a column:
=IF(OR(N4:N300=E1),TRUE,FALSE)
confirmed as an array formula (Ctrl+Shift+Enter) will work.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tabatha" wrote:

I need to know how to compare a cell address in one column and find if that
cell location is in another column.

I thought that i would use the if function and my formula was
=if(e1=n4:n300,true,false) but this does not seem to work any help would be
appreciated.

Comparing Information in 2 columns
 

Luke you have been awesome thanks

I just have one more question (I think). I thought that after I did the Is
number funtion to get the true/false answer I would be able to sort by that
column (descending) and all the trues would go to the top and all the falses
would go to the bottom. This in not working they are still all intermingled
with each other do you have any idea why? Is this something that I should be
able to do?

"Luke M" wrote:

The formlula I posted earlier should work if you're trying to compare a
single cell to an array of cells. (sorta sounds like what you're doing).

Actually, a better, non-array formula is:
=ISNUMBER(MATCH(E1,N4:N300,0))

If E1's value is found anywhere in N4:N300, formula returns TRUE, else FALSE.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tabatha" wrote:

I have this formula in column N
=ADDRESS(MATCH(M4,D$2:$D$981,0)+ROW(D2)-1,COLUMN(D2),4)

Then I have this formula in column e =ADDRESS(ROW(D2)-1,COLUMN(D2),4)

I want to do a formula that will let me know if the cell in Column E is
matched in Column N. Is this Possible? That is what I was trying to use the
find function for.

"Luke M" wrote:

cell location/addesses can not change, nor can they be equal. (A2 is an
address, there is no way another cell can be on same sheet, and same address!)

If you want to know if the value of one cell is present in a column:
=IF(OR(N4:N300=E1),TRUE,FALSE)
confirmed as an array formula (Ctrl+Shift+Enter) will work.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tabatha" wrote:

I need to know how to compare a cell address in one column and find if that
cell location is in another column.

I thought that i would use the if function and my formula was
=if(e1=n4:n300,true,false) but this does not seem to work any help would be
appreciated.

Comparing Information in 2 columns
 

try to use MATCH function


On 26 Lut, 16:38, Tabatha wrote:
I need to know how to compare a cell address in one column and find if that
cell location is in another column. *

I thought that i would use the if function and my formula was
=if(e1=n4:n300,true,false) but this does not seem to work any help would be
appreciated. *