| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Is it possible to have a sum in a Vlookup?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
See if this is what you had in mind...
...........A..........B 1........x...........3 2........z...........4 3........x...........1 4........x...........4 5........y...........2 Sum column B where column A = x: =SUMIF(A1:A5,"x",B1:B5) -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Is it possible to have a sum in a Vlookup? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Can I send you a sample of the file and show you what I'm trying to
accomplish? There is too much to be able to explain here and I think an actual illustration might help. Thanks! "T. Valko" wrote: See if this is what you had in mind... ...........A..........B 1........x...........3 2........z...........4 3........x...........1 4........x...........4 5........y...........2 Sum column B where column A = x: =SUMIF(A1:A5,"x",B1:B5) -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Is it possible to have a sum in a Vlookup? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
How do I know you won't send me a nasty virus?
What you could do is use any of several free file hosting sites. You'd upload your file to the file host site then post a link to that file. Anyone interested could then download the file to look at it. -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Can I send you a sample of the file and show you what I'm trying to accomplish? There is too much to be able to explain here and I think an actual illustration might help. Thanks! "T. Valko" wrote: See if this is what you had in mind... ...........A..........B 1........x...........3 2........z...........4 3........x...........1 4........x...........4 5........y...........2 Sum column B where column A = x: =SUMIF(A1:A5,"x",B1:B5) -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Is it possible to have a sum in a Vlookup? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
I don't have a problem doing that at all. I certainly understand your
concern. Thank you! "T. Valko" wrote: How do I know you won't send me a nasty virus? What you could do is use any of several free file hosting sites. You'd upload your file to the file host site then post a link to that file. Anyone interested could then download the file to look at it. -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Can I send you a sample of the file and show you what I'm trying to accomplish? There is too much to be able to explain here and I think an actual illustration might help. Thanks! "T. Valko" wrote: See if this is what you had in mind... ...........A..........B 1........x...........3 2........z...........4 3........x...........1 4........x...........4 5........y...........2 Sum column B where column A = x: =SUMIF(A1:A5,"x",B1:B5) -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Is it possible to have a sum in a Vlookup? . . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Do you know of one that I could use? Because this is a company computer, I'm
not able to go to all websites. It's blocked due to security reasons. If you don't know of one I can use, then I'll try and post here, but it's difficult to add everything I need here to give you a good idea of what I'm doing. Thanks again! "T. Valko" wrote: How do I know you won't send me a nasty virus? What you could do is use any of several free file hosting sites. You'd upload your file to the file host site then post a link to that file. Anyone interested could then download the file to look at it. -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Can I send you a sample of the file and show you what I'm trying to accomplish? There is too much to be able to explain here and I think an actual illustration might help. Thanks! "T. Valko" wrote: See if this is what you had in mind... ...........A..........B 1........x...........3 2........z...........4 3........x...........1 4........x...........4 5........y...........2 Sum column B where column A = x: =SUMIF(A1:A5,"x",B1:B5) -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Is it possible to have a sum in a Vlookup? . . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
I found one that would work. Here is the link to the file:
http://fastfreefilehosting.com/getfile.php? Thanks again! "LWilson" wrote: Do you know of one that I could use? Because this is a company computer, I'm not able to go to all websites. It's blocked due to security reasons. If you don't know of one I can use, then I'll try and post here, but it's difficult to add everything I need here to give you a good idea of what I'm doing. Thanks again! "T. Valko" wrote: How do I know you won't send me a nasty virus? What you could do is use any of several free file hosting sites. You'd upload your file to the file host site then post a link to that file. Anyone interested could then download the file to look at it. -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Can I send you a sample of the file and show you what I'm trying to accomplish? There is too much to be able to explain here and I think an actual illustration might help. Thanks! "T. Valko" wrote: See if this is what you had in mind... ...........A..........B 1........x...........3 2........z...........4 3........x...........1 4........x...........4 5........y...........2 Sum column B where column A = x: =SUMIF(A1:A5,"x",B1:B5) -- Biff Microsoft Excel MVP "LWilson" wrote in message ... Is it possible to have a sum in a Vlookup? . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
