drgregur@gmail.com
New member
- Joined
- Jan 16, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi, i have som problem to find out how to put togheter a formula .
A B C D
2 3 4 5 (Zone)
1 22 44 66 12 Country: USA Result Zone: 2
2 33 55 77 13 Weight: 4 kg
3 44 66 88 14
4 55 77 99 15 Price: 55 USD
KG...
First, i lookup a name in a List ex. USA, and that return a nr. ex. 2 (column, the 2-5)
Then i want to use that nr. to give me back a price in my list , BUT the lookup must include another nr. (weight,1-4 downwards).. messy..
In clean text. I get back a "Zone" nr. ex. Zone 2,
And i also have enter a weight, and i want it to search up that weight in Zone 2 and send back a price in the list...
SOmething like "Lookup(USA;A2:A5,B2:B5)" Result: Zone 2 ... and i stuck with the rest
A B C D
2 3 4 5 (Zone)
1 22 44 66 12 Country: USA Result Zone: 2
2 33 55 77 13 Weight: 4 kg
3 44 66 88 14
4 55 77 99 15 Price: 55 USD
KG...
First, i lookup a name in a List ex. USA, and that return a nr. ex. 2 (column, the 2-5)
Then i want to use that nr. to give me back a price in my list , BUT the lookup must include another nr. (weight,1-4 downwards).. messy..
In clean text. I get back a "Zone" nr. ex. Zone 2,
And i also have enter a weight, and i want it to search up that weight in Zone 2 and send back a price in the list...
SOmething like "Lookup(USA;A2:A5,B2:B5)" Result: Zone 2 ... and i stuck with the rest