match a value

[harris1234]

hi everyone; can you help me find a solution to this problem.

Column A Column B
NARHA01 NARHA02
NARHA03 NARHA03
NARHA02 NARHA11

Column A is the data now in column B i intentionally made an error B3 how can i know that B3 is not in data or error and giving me the line were the errors are.

thanks alot
harris

[Pete_UK]

Put this in C1:

=IF(ISNA(MATCH(B1,A:A,0)),"Error","OK")

then copy down.

Hope this helps.

Pete

[Sindhus]

Hi,

You can try match formula.

Please Login or Register  to view this content.

If value is available in A column, it will return the row number. Otherwise it returns error.

Regards,
Sindhu

[harris1234]

thanks alot for helping. this solve my problem partially.

is there any way that in 1 cell example in C1, there is a note or anything that can tell that B3 is error? because i have seen one but i cant remember where. if there are 10 errors example it will flash at cell C1 those others.

thanks alot

[harris1234]

thanks alot for helping. this solve my problem partially.

is there any way that in 1 cell example in C1, there is a note or anything that can tell that B3 is error? because i have seen one but i cant remember where. if there are 10 errors example it will flash at cell C1 those others.

thanks alot

[Pete_UK]

My formula puts the word "Error" in column C if there is no match. All you need to do is apply a filter to that column and select the word Error from the filter drop-down to see a list of all of them.

Hope this helps.

Pete

[harris1234]

yes sir pete i see that. but what i am trying to solve is for example in cell C1 of my previous inquiry it will flash all the errors in comment or note forms

i think this needs a VBA?

thanks alot

[Pete_UK]

I would advise you against flashing or blinking text. Also, a formula cannot return a comment, so you would need VBA to do that.

Pete