Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a formula.
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. |