So i'm looking for the same characteristics as SUMIFS or SUMPRODUCT function but without the sum part. The data tab i'm working with has two fields that i need to lookup based on. But when i use a SUMIFS or SUMPRODUCT, it sums the blank value (just a single row will correspond to the two fields) to be 0. I need it just to pull the single value it finds and not sum it into 0. But sadly, there are some cases where the legit pull is 0, so i can't IF my way around it.
The reason, in case it might help, is i'm using this value in a VLOOKUP to pull yet another value. So when the sumifs show 0, i get a very different result than if it pulled "".
I appreciate your help.
Chris
Bookmarks