sumproduct and vlookup

T

Tami

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?
 
B

Bob Phillips

Have you actually tried?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
T

Tami

actually i don't know how i would write the
formula....vlookup(cell,range,col#)...so the range is usually something like
$A$2:$F$300...so how would i specify multipy sheets/ranges?
 
Top