Help with LOOKUP in a pricelist.

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 :(
 
Top