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),"")