Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
USING VLOOKUP AND HLOOKUP
I NEED TO BE ABLE TO SET A FORMUAL TO DO THE FOLLOWING:
B1=3,B2=21,B3=16 i WANT TO TAKE THESE RESULTS FROM A LIST TO PRINT THE RESULTS. THE LIST IS LIKE: 15 16 17 18 3 20 $10 $20 $30 $40 3 21 $15 $25 $35 $45 3 22 $16 $17 $18 $19 i WANT TO BE ABLE TO FIND 3 , 21 , 16 AND PRINT THE RESULT. THE EXAMPLE THE RESULT IS $25 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
USING VLOOKUP AND HLOOKUP
Say your datalist was in C1 to H4.
C1 and D1 are empty, as in your example. Try this: =SUMPRODUCT((C2:C4=B1)*(D2:D4=B2)*(E1:H1=B3)*E2:H4 ) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Glenn" wrote in message ... I NEED TO BE ABLE TO SET A FORMUAL TO DO THE FOLLOWING: B1=3,B2=21,B3=16 i WANT TO TAKE THESE RESULTS FROM A LIST TO PRINT THE RESULTS. THE LIST IS LIKE: 15 16 17 18 3 20 $10 $20 $30 $40 3 21 $15 $25 $35 $45 3 22 $16 $17 $18 $19 i WANT TO BE ABLE TO FIND 3 , 21 , 16 AND PRINT THE RESULT. THE EXAMPLE THE RESULT IS $25 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and hlookup | Excel Worksheet Functions | |||
Nesting VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
VLookup & HLookup | Excel Discussion (Misc queries) | |||
VLookup and HLookup at the same time | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions |