I need a formula.

[Brandon Cariveau]

Situation: I have two different sheets that I need to match up in a way. I
need to look at the cells in column A on sheet 1 and have it look at the
cells in column H on sheet 2. If the info in the cells in column A on sheet
1 match the column H on sheet 2, then back on sheet 1 place a "true or false"
in column P lined up with the matching cells. What I will be doing is
deleting the ones that don't match (false). Otherwise I am going thru a
couple thousand lines of parts numbers to get rid of old ones that are no
longer on the master price list.

 

[Pete_UK]

Put this in P1 of Sheet1:

=ISNA(MATCH(A1,Sheet2!H:H,0))

Then copy down.

Hope this helps.

Pete

 

[Brandon Cariveau]

Thanks all who helped. The suggestions did not work but both looked like
they would. My thought is that the cells have some strange formating that is
not letting these search formulas return correct answers. I didn't make
these sheets but I am left looking through them.

Thanks again!!

 

[stew]

Dear Brandon

Try This in P1
=IF(A1=Sheet2!H1,"TRUE","FALSE")

I have tried it and it does work