Thank you that does work to an extent, however my cell keeps returning #VALUE
as it is text I am trying to return not numbers, any suggestions on a way
round this?

Thanks,
Ross



"Franz Verga" wrote:

Nel post
*Ross* ha scritto:

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

Hi Ross,

maybe this is good for you:

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


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy