Hi,

Do you have XLOOKUP?  If so you can use this:

=XLOOKUP(G3,$E$3:$E$22,$A$3:$A$22,,1)

See the attached workbook.

Regards

Phil

Thanks Philip for the immediate reply.

Only the problem....I don't have XLOOKUP..

How to get it and install. I am using EXCEL 2013 version.

Thanks.

Bala

Hi Bala,

See attached.  The formula in Col J is an array formula that you will need to enter with CTRL+SHIFT+ENTER but does the job:

=MATCH(MIN(IF($E$3:$E$22>=G3,$E$3:$E$22)),$E$3:$E$22)

Regards

Phil

If the data is sorted you can use =INDEX($A$3:$A$22,MATCH(G3,$E$2:$E$22,1))

Purfleet