Question
What is the function of
"LOOKUP"?Solution
LOOKUP function is used to look in a single row or column and find a value from the same position in a second row or column.
A shopkeeper blends 5 kg of coffee at Rs. 12 per kg with 7 kg at Rs. 8 per kg. What is the cost price (in Rs.) of the mixture per kg?
A mixture of 140 lit contains milk and water where milk is 20 lit more than water. If 28 lit mixture is taken out and 12 lit pure milk is added then rat...
The ratio of the quantity of juice and water in vessel A and vessel B is 3:2 and 4:3 respectively. 45 liters of mixture is taken out from vessel A and p...
- Out of a 200-litre solution of juice and soda, the ratio of juice to soda is 1:4. How many litres of juice should be added to make the new ratio 3:8?
A mixture contains 100 ml of milk and 25 ml of water. If 25 ml of the mixture is replaced with 15 ml of water, then find the ratio of quantity of milk ...
In a mixture of milk and water, the amount of milk is 37 ml greater than the amount of water. After 75% of the mixture is removed and 10.75 ml of milk i...
- Two mixtures, P and Q, have milk-to-sugar ratios of 8:11 and 10:15, respectively. When these two mixtures are combined, the total quantity of the final mix...
Glass S initially holds 200 ml of coke, while Glass T contains 110 ml of soda. First, 40 ml of coke is transferred from Glass S to Glass T. Then, 30 ml ...
A merchant mixes 9 kg of beans at Rs. 7 per kg with 6 kg at Rs. 5 per kg. What is the cost price (in Rs.) of the mixture per kg?
- An alloy consists of 35% gold, 40% silver, and 25% copper. How much gold should be added to 20 kg of the alloy so that the new alloy contains 50% gold?
