Hello,

How do you get excel to ignore certain data when reading a cell?

I want to use VLOOKUP to match a cell reading "NP001" with "N001"

Or even better I want to use it in a SumProduct Formula:

=SUMPRODUCT((A1:A10="N001")*(B1:B10=--"02/06/06");C1:C10)

Thanks,
P