sumproduct and vlookup

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

 

[Bob Phillips]

Have you actually tried?

--
---
HTH

Bob


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

 

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