Check if cell = another cell

[ThePatrickBay]

Hello,

I have run into a problem.

I need to check if my ItemCode-cell = an ItemCode-cell in another document. If true, it should write from a cell in the other document. If false, it should just be blank.

I have tried this:

Please Login or Register  to view this content.

If the ItemCode in Document 1 = any ItemCode in 'Vareliste 21-06-2012.xlsx', it should write the 'Konk. Pris' cell text from the row that contains the proper ItemCode. If there is no ItemCode match, then just "".

What am I doing wrong?

Thanks,
Patrick

[radiant0619]

Attach the excel with data pls

[FDibbins]

i think a simpler formula should give you what you need...

=if(1st-cell-to-check=2nd-cell-to-check, the-cell=you-want-the-value-from, "")

[icestationzbra]

unless you are trying to compare case-sensitive text strings in two places, avoid EXACT and go with @fdibbins' suggestion. see if that helps you any.

[ThePatrickBay]

i think a simpler formula should give you what you need...

=if(1st-cell-to-check=2nd-cell-to-check, the-cell=you-want-the-value-from, "")

Well, yes, that would partly solve the problem I have, but it needs to check if any cell in the ItemCode col has the value.

=if($A$2=Any cell in column A;[@[Konkur. Pris]] to the corresponding [@ItemCode];"")

That is what I want to do.

[icestationzbra]

let us say that you have $A$2 value in Sheet1 that you want to check for existence in Sheet2's entire column A, you would use something like this to check that:

Please Login or Register  to view this content.

in your formula, that might translate to (check to confirm):

Please Login or Register  to view this content.