FU to old thread on VLOOKUP

[peacelittleone]

This is actually a follow-up to an old thread titled: "vlookup to see 2 values?"

I was able to get the formula to work for me...

=INDEX('2005 Raw Data'!$E$2:$E$23,MATCH(1,('2005 Raw Data'!$A$2:$A$23='2005'!$A5)*('2005 Raw Data'!$C$2:$C$23='2005'!B$1),0),0)

However - I need a way to suppress the #N/A's I get where I don't have data. My preference is to display 0's.

Any help is most certainly appreciated!

TIA!!!

Heather.

[Domenic]

Try...

=IF(ISNA(MATCH(1,('2005 Raw Data'!$A$2:$A$23='2005'!$A5)*('2005 Raw Data'!$C$2:$C$23='2005'!B$1),0)),0,INDEX('2005 Raw Data'!$E$2:$E$23,MATCH(1,('2005 Raw Data'!$A$2:$A$23='2005'!$A5)*('2005 Raw Data'!$C$2:$C$23='2005'!B$1),0),0))

...confirmed with CONTROL+SHIFT+ENTER. Although, my preference is to use Conditional Formatting to hide #N/A's.

Hope this helps!

[peacelittleone]

Worked like a charm!

Thank you much!