| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with 2 vaiables
In sheet 1 I have the followng info
A B C 1 raj neworders 15 2 raj orders 2 In sheet 2 I want find how many neworders for raj and how many orders for raj but those info wont be in the same place in sheet 1 all the time and sometimes the info from row 2 will be in row 1 because sheet 1 is not a regular excel file. i'll exporting from crystal report. I need fucntion to look up if that is raj what is the neworder and if that is raj what is orders. thank you in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with 2 vaiables
Hi,
I assume that in Sheet2 you have in A1 The name "raj" and in B1 you have "New orders" so in c1 enter =sumproduct(--(A1=sheet1!$A$1:$A$1000),(B1=sheet1!$B$1:$B$1000), $C$1:$C$1000) "ganga" wrote: In sheet 1 I have the followng info A B C 1 raj neworders 15 2 raj orders 2 In sheet 2 I want find how many neworders for raj and how many orders for raj but those info wont be in the same place in sheet 1 all the time and sometimes the info from row 2 will be in row 1 because sheet 1 is not a regular excel file. i'll exporting from crystal report. I need fucntion to look up if that is raj what is the neworder and if that is raj what is orders. thank you in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with 2 vaiables
actually i don't need the sum. the info in sheet 1 will be anywhere in that
sheet and and i want to find those info and populate it in sheet 2. "Eduardo" wrote: Hi, I assume that in Sheet2 you have in A1 The name "raj" and in B1 you have "New orders" so in c1 enter =sumproduct(--(A1=sheet1!$A$1:$A$1000),(B1=sheet1!$B$1:$B$1000), $C$1:$C$1000) "ganga" wrote: In sheet 1 I have the followng info A B C 1 raj neworders 15 2 raj orders 2 In sheet 2 I want find how many neworders for raj and how many orders for raj but those info wont be in the same place in sheet 1 all the time and sometimes the info from row 2 will be in row 1 because sheet 1 is not a regular excel file. i'll exporting from crystal report. I need fucntion to look up if that is raj what is the neworder and if that is raj what is orders. thank you in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with 2 vaiables
Hi,
A sample of your data and a description of exactly what you want to achieve will be helpful "ganga" wrote: actually i don't need the sum. the info in sheet 1 will be anywhere in that sheet and and i want to find those info and populate it in sheet 2. "Eduardo" wrote: Hi, I assume that in Sheet2 you have in A1 The name "raj" and in B1 you have "New orders" so in c1 enter =sumproduct(--(A1=sheet1!$A$1:$A$1000),(B1=sheet1!$B$1:$B$1000), $C$1:$C$1000) "ganga" wrote: In sheet 1 I have the followng info A B C 1 raj neworders 15 2 raj orders 2 In sheet 2 I want find how many neworders for raj and how many orders for raj but those info wont be in the same place in sheet 1 all the time and sometimes the info from row 2 will be in row 1 because sheet 1 is not a regular excel file. i'll exporting from crystal report. I need fucntion to look up if that is raj what is the neworder and if that is raj what is orders. thank you in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Temp vaiables in formulas? | 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 | |||
| I need a VLOOK-UP formula that uses two look-up vaiables in seper. | Excel Worksheet Functions | |||
Linear Mode
