Double Lookup

[DoosanRuss]

Hello All
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
<o></o>
<o></o>
I've been working on this all day and I could really do with a hand <o></o>
<o></o>
<o></o>
What I'm looking to do is lookup the NB value (S2) in column A4:A35, then get the closest Match for the ºC value (T2) in column G4:G35 and return the Cost (£) in column O (for Oscar).

https://docs.google.com/leaf?id=0B9...IxODQtNjQwYmRhMTliMjg1&hl=en&authkey=CKmq_PQB
<o></o>
<o></o>
I've tried putting in a helper column and using formula =A4&G4

<o></o>
Then using a single lookup to the helper column, I thought this was working fine until I changed the range_lookup to ‘1’ “Closest Match” as sometimes ºC might not be exactly as listed.

<o></o>
The problem I found: NB 25 & 30 ºC = 2530
NB 25 & 300 ºC =25300
<o></o>
If I use closest match for 30 ºC it goes to the 25300 version, which is more expensive.

<o></o>
I’ve also tried C Pearson examples = INDEX(A4:G35,MATCH(MIN(ABS(A4:G35-S2)),ABS(A4:G35-T2),0),1)
<o></o>
<o></o>
But I can’t align the list into ascending order to suit this formula

<o></o>
Any help will as always be gratefully received<o></o>
<o></o>
<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><o></o>
<o></o>