LookUp Function

[twixy2k]

Hello!

I'm running Excel XP and trying to figure how to run vlookup from tw
colums.

The form is for working out the next standard size up. Enter number i
A and a number in B and in C it pulls thro the code from 'datarange
where A is more then or Equals 'datarange coloum A' AND B is more the
or Equals 'datarange coloum B'

Any Ideas.

Please find attached JPG.

Hope i've explained enough.

Thanks

Ala

+----------------------------------------------------------------
| Attachment filename: excel1.jpg
|Download attachment: http://www.excelforum.com/attachment.php?postid=359266
+----------------------------------------------------------------

 

[Peo Sjoblom]

Try something like

=INDEX(DataRange!$C$2:$C$20,MATCH(1,(DataRange!$A$2:$A$20>=A2)*(DataRange!$B
$2:$B$20>=B2),0))

entered with ctrl + shift & enter

as you can se I use the opposite that the datarange is greater than or
equal, else I can't see how you could get the results you got

 

[twixy2k]

Crap! My mistake
Its ment was to find where A is less then or equals datarange coloum
AND B is Less then or equals datarange coloumB. And for it to first th
first entry that appears in coloum C


Thank