Lookup formula

[strongman86]

Guys,
Need formula to put in column F to lookup at column A & B and find matching colour and return adjacent weight value. Thanks.

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Colour[/TD]
[TD]Weight[/TD]
[TD][/TD]
[TD][/TD]
[TD]Colour[/TD]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Red[/TD]
[TD]1.44[/TD]
[TD][/TD]
[TD][/TD]
[TD]Red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Blue[/TD]
[TD]1.55[/TD]
[TD][/TD]
[TD][/TD]
[TD]Red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Green[/TD]
[TD]2.00[/TD]
[TD][/TD]
[TD][/TD]
[TD]Blue[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Blue[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

Re: Lookup formula help

in F2

> =VLOOKUP(E2,$A$2:$B$4,2,0) and drag down

 

[strongman86]

Re: Lookup formula help

Cheers