ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sumproduct and vlookup (https://www.excelbanter.com/excel-worksheet-functions/189744-sumproduct-vlookup.html)

Tami

sumproduct and vlookup
 
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

sumproduct and vlookup
 
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?




Tami

sumproduct and vlookup
 
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?






All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com