Posted to microsoft.public.excel.misc

Ross

Posts: n/a

Ignoring certain data

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ignoring Rows When Extracting Data From One Worksheet To Another	Jim J.	Excel Worksheet Functions	2	May 8th 06 04:55 PM
ranking query	JaimeTimbrell	Excel Discussion (Misc queries)	2	February 16th 06 08:09 AM
Importing Data	Jillian	Excel Worksheet Functions	9	December 23rd 05 12:45 PM
Ignoring 0 values in the series data	Alison	Charts and Charting in Excel	5	August 16th 05 03:10 PM
Line Graph Data Recognition	Nat	Charts and Charting in Excel	2	April 30th 05 02:07 PM

All times are GMT +1. The time now is 03:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us