G
Guest
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
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