cell to reference another cells data from a table...

[rpo83]

Hi All,

i struggled with the title for this question... sorry.

What i'm trying to do is to set a freight value from a table of variables. I have a multi page workbook where page 1 is all the variables we need to consider.

Column 1 on all other pages lists product category A to H, what i want to do is have my freight calculation to read the column 1 value (a-h), then lookup that value on my variables page to apply the freight value in $

I hope i have explained that well enough...

 

[Yongle]

Create Named Range Freight

and then use in VLOOKUP

Book1
	A	B
1	Category	Charge
2	g	7
3	d	4
4	a	1
5	b	2
Sheet2

Cell Formulas
Range	Formula
B2:B5	B2	=VLOOKUP(A2,Freight,2,0)

 

[rpo83]

Thank you Yongie, i'll have a crack at that and see how i go..