Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel lookup
I need to find the formula where there are two dependencies considered to get
the result.In V look up from reference of one column the results in the second columns derived. If we want to find out the result with the reference of two.what is the formulae. Heads Ratio Rate Brickwork 1:5 30 Brickwork 1:6 45 Plaster 1:5 35 Plaster 1:6 50 Head- Ratio- Rate- If I enter head in one cell ratio in another which formulae will give me appropriate rate? Head- Brickwork Ratio- 1:5 Rate- Formulae? -- If you win you need not explain, if you loose you should not be there to explain. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel lookup
Hi,
I assume heads in column A, ratio in B and rate in C, then in D1 you enter your heads, in E1 you enter the ratio so in F1 enter =sumproduct(--(D1=$A$1:$A$100),--(E1=$B$1:$B$100),$C$1:$C$100) "Maximus" wrote: I need to find the formula where there are two dependencies considered to get the result.In V look up from reference of one column the results in the second columns derived. If we want to find out the result with the reference of two.what is the formulae. Heads Ratio Rate Brickwork 1:5 30 Brickwork 1:6 45 Plaster 1:5 35 Plaster 1:6 50 Head- Ratio- Rate- If I enter head in one cell ratio in another which formulae will give me appropriate rate? Head- Brickwork Ratio- 1:5 Rate- Formulae? -- If you win you need not explain, if you loose you should not be there to explain. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |