About Us

Spencer101

Quote:

Originally Posted by tobnull

That one works gives me what I am looking for but one thing:
1. several cells have #N/A

Tried <"" at the end but that just screwed up the formula giving me a false answer. Is there away to get a cell that does not match to be either blank or have a 0?

On the proviso you're using Excel 2007 or later, you can use...

=IFERROR(VLOOKUP($A2,'May 2012 Report'!$A$2:$D$21,4,FALSE),"")

tobnull

Quote:

Originally Posted by Spencer101

On the proviso you're using Excel 2007 or later, you can use...

=IFERROR(VLOOKUP($A2,'May 2012 Report'!$A$2:$D$21,4,FALSE),"")

This works great. Thanks

Spencer101

Quote:

Originally Posted by tobnull

This works great. Thanks

Not a problem. Anytime! :)

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data label doesn't match data point!	kippers	Charts and Charting in Excel	4	April 8th 09 07:29 AM
Complex Summing probably using Match at some point...	George	Excel Worksheet Functions	2	October 10th 07 05:39 PM
Data point on line is not over the point/tick in X axis...	TomCat	Charts and Charting in Excel	2	September 6th 07 01:36 PM
formula to identify exact point where trendline intersects data	Jane	Excel Worksheet Functions	5	November 14th 06 11:09 PM
pull data for a company with data in diff cells multiple wrkshts	kcoachbiggs	Excel Worksheet Functions	0	March 8th 06 09:24 PM

Menu

About Us