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?

Have you actually tried?

--
---
HTH

Bob


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



"Tami" wrote in message
...
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?

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?

"Bob Phillips" wrote:

Have you actually tried?

--
---
HTH

Bob


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



"Tami" wrote in message
...
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?