![]() |
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? |
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? |
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