Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Help
Hello,
I have a data sheet with information in rows and I use vlookup to match the date/operation/crew and return a value in one of the columns. Now, I have multiple entries where the same date/operation/crew could occur in the same day. Ideally, I want to combine math data in the other cells and have one entry return from my vlookup formula. I already use a helper cell to get the date/operation/crew criteria concatenated, then use that as my lookup value. If anyone could provide assistance, I would very much appreciate it. Thanks, Bruce |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Help
Need more specific info/details.
-- Biff Microsoft Excel MVP "brumanchu" wrote in message ... Hello, I have a data sheet with information in rows and I use vlookup to match the date/operation/crew and return a value in one of the columns. Now, I have multiple entries where the same date/operation/crew could occur in the same day. Ideally, I want to combine math data in the other cells and have one entry return from my vlookup formula. I already use a helper cell to get the date/operation/crew criteria concatenated, then use that as my lookup value. If anyone could provide assistance, I would very much appreciate it. Thanks, Bruce |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Help
Example:
A B C D E F G 1 11/1 C X 100 100 =d/e =concatenate(A,B,C) 2 11/1 C Y 90 100 =d/e =concatenate(A,B,C) 3 11/2 D X 85 120 =d/e =concatenate(A,B,C) 4 11/2 D Y 105 120 =d/e =concatenate(A,B,C) 5 11/3 C X 97 100 =d/e =concatenate(A,B,C) 6 11/3 C Y 68 100 =d/e =concatenate(A,B,C) I use vlookup(concatenate(A,B,C),A1:G6,6) to return the value in column F (column G is actually in the column A position, i didn't want to retype it after I noticed) The process works great when this is the case. However, not I have data that looks like this: A B C D E F G 1 11/1 C X 40 50 =d/e =concatenate(A,B,C) 2 11/1 D X 50 50 =d/e =concatenate(A,B,C) 3 11/1 C Y 90 100 =d/e =concatenate(A,B,C) 4 11/2 D X 85 120 =d/e =concatenate(A,B,C) 5 11/2 D Y 105 120 =d/e =concatenate(A,B,C) 6 11/3 C X 97 100 =d/e =concatenate(A,B,C) 7 11/3 C Y 68 100 =d/e =concatenate(A,B,C) Where on 11/1 crew X worked on both C & D products and output 40 & 50 respectively. Vlookup only returns the first 11/1CX column F value, and I want to add row 1 & row 2 together to get one value for the date 11/1CX column F Hope this clarifies. Bruce "T. Valko" wrote: Need more specific info/details. -- Biff Microsoft Excel MVP "brumanchu" wrote in message ... Hello, I have a data sheet with information in rows and I use vlookup to match the date/operation/crew and return a value in one of the columns. Now, I have multiple entries where the same date/operation/crew could occur in the same day. Ideally, I want to combine math data in the other cells and have one entry return from my vlookup formula. I already use a helper cell to get the date/operation/crew criteria concatenated, then use that as my lookup value. If anyone could provide assistance, I would very much appreciate it. Thanks, Bruce . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Help
OK, you want to sum column F using the criteria concatenate(A,B,C) ?
Try this... =SUMIF(G1:G10,J1,F1:F10) Where J1 = concatenate(A,B,C) -- Biff Microsoft Excel MVP "brumanchu" wrote in message ... Example: A B C D E F G 1 11/1 C X 100 100 =d/e =concatenate(A,B,C) 2 11/1 C Y 90 100 =d/e =concatenate(A,B,C) 3 11/2 D X 85 120 =d/e =concatenate(A,B,C) 4 11/2 D Y 105 120 =d/e =concatenate(A,B,C) 5 11/3 C X 97 100 =d/e =concatenate(A,B,C) 6 11/3 C Y 68 100 =d/e =concatenate(A,B,C) I use vlookup(concatenate(A,B,C),A1:G6,6) to return the value in column F (column G is actually in the column A position, i didn't want to retype it after I noticed) The process works great when this is the case. However, not I have data that looks like this: A B C D E F G 1 11/1 C X 40 50 =d/e =concatenate(A,B,C) 2 11/1 D X 50 50 =d/e =concatenate(A,B,C) 3 11/1 C Y 90 100 =d/e =concatenate(A,B,C) 4 11/2 D X 85 120 =d/e =concatenate(A,B,C) 5 11/2 D Y 105 120 =d/e =concatenate(A,B,C) 6 11/3 C X 97 100 =d/e =concatenate(A,B,C) 7 11/3 C Y 68 100 =d/e =concatenate(A,B,C) Where on 11/1 crew X worked on both C & D products and output 40 & 50 respectively. Vlookup only returns the first 11/1CX column F value, and I want to add row 1 & row 2 together to get one value for the date 11/1CX column F Hope this clarifies. Bruce "T. Valko" wrote: Need more specific info/details. -- Biff Microsoft Excel MVP "brumanchu" wrote in message ... Hello, I have a data sheet with information in rows and I use vlookup to match the date/operation/crew and return a value in one of the columns. Now, I have multiple entries where the same date/operation/crew could occur in the same day. Ideally, I want to combine math data in the other cells and have one entry return from my vlookup formula. I already use a helper cell to get the date/operation/crew criteria concatenated, then use that as my lookup value. If anyone could provide assistance, I would very much appreciate it. Thanks, Bruce . |
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 -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |