Associate/Find Nos and Return Equal/Greater

Hi All

May I ask the board if they could advise on how I can get a formula to find numbers associated with other numbers and then find the numbers that are equal or greater to that query. A guide is also included in the sheet.

I have attached a sheet as below.

Thanks in advance.

Kind Regards

MAIN.xls

Originally Posted by MarvinP

Hi Celticshadow,

See if the formula is correct in the attached.

Hi Marin P

Absolutely superb, that fromula works a treat. I have been scratching my head all night over that. Many thanks for responding so quickly you are a credit to yourself and the forum.

Kind Regards