Associate/Find Numbers and return Equal/Greater

[Celticshadow]

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 as I am unsure how to upload a file.

Thanks in advance.

Kind Regards

https://spreadsheets.google.com/ccc...RZzdnQUFSdjlxRHc&hl=en&authkey=CLDR9fAD#gid=0

 

[Gerald Higgins]

Hi.

Can you post a few examples please (sorry, I'm not looking at your link).

 

[Haseeb Avarakkan]

Hello, Try

All are the Array Formulas. Must hit Control+Shift+Enter, not just Enter.


A2;

=MAX(IF(D$1:AZ$1="Main",D2:AZ2))

B2;

=MAX(IF(D$1:AZ$1="L",D2:AZ2))


C2;

=MAX(IF(D$1:AZ$1="H",IF(D2:AZ2>B2,D2:AZ2)))

Copy down...