Lookup by multiple criteria

**teylyn** · 07-08-2010, 08:40 AM

explain to me:

Bangkok		BKK		TH		15
		BKK		TH		
Brisbane		BNE		AU		50KG
		BNE		AU		
Johannesburg		JNB		ZA	6000	10
					-6000	10
					-3000	10
					-2000	10

what is "-50" in row 3? Can a piece of freight have negative weight?

The blank rows in your data column will be a problem. You need unique codes in column A or in column C.

Then fix row 3 to be meaningful steps of weight categories and just adapt the formula I posted earlier to reflect the rows and columns you are using right now.

cheers.

**airfreight** · 07-14-2010, 05:40 AM

Originally Posted by teylyn

explain to me:

Bangkok		BKK		TH		15
		BKK		TH		
Brisbane		BNE		AU		50KG
		BNE		AU		
Johannesburg		JNB		ZA	6000	10
					-6000	10
					-3000	10
					-2000	10

what is "-50" in row 3? Can a piece of freight have negative weight?

The blank rows in your data column will be a problem. You need unique codes in column A or in column C.

Then fix row 3 to be meaningful steps of weight categories and just adapt the formula I posted earlier to reflect the rows and columns you are using right now.

cheers.

Just wanted to say thanks, amanaged to adapt your formula, still not sure how it works but very grateful for your help

Thanks

ian