VLOOKUP a range

[Martindelica]

Hi there, I have 10 groups of in a range.EG

Range
0.25 - 0.5   A
0.5 - 0.7     B
0.7 - 0.8     C 
0.8 - 2        D

How can I use the VL formula using a value in cell A1 to find out which group it belongs to. Also group B and D are special and I would like for the VL formula to return them in bold.

VLOOKUP(A1,Sheet2!,A:B,2)
Something like this?

[VBA Noob]

Does this help

VBA Noob

[Martindelica]

Dude, you teach me so much. Thanks alot. It helps big time!

Martin.

[daddylonglegs]

You could also use this formula to get the same result

=IF(A3<E3,"Not found",LOOKUP(A3,E3:G6))