normally when i use sumproduct and vlookup i'm searching a table within the
spreadsheet....but what if i have a table on sheet a, b and c in the same
file....in other words, can i do a search (vlookup/sumproduct) across
multiple sheets to find a match?