VLookup

[gdallas]

Hi,

I craeted a simple sheet, and would like to select a motor size, given the "look up value" cell.

I need it to go the oposite way when slecting it, i.e. where "3.1" is the lookup value, it should select "4", and not "3"

how would i achive this?

Many thanks

[canapone]

Hi,

if you sort descending your data in column A (400, 355, 315...) you could try in L21


=INDEX(A4:A32,MATCH(L20,A4:A32,-1))

Regards

[windknife]

Try this
=INDEX($A$4:$A$100,MATCH(TRUE,INDEX($A$4:$A$100>=L20,0),0))

HTH,
windknife

[gdallas]

Thanks Guys, both excellent solutions, but went with windknife's