Macro to compare value against a range & return result

[New VBA User]

I have a user who selects value from drop-down. That value should be compared against the values in master sheet.

A B C
THPUT 60 160 480
PT 48 24 70
PoE 15.4 15.4 30
ST No Yes Yes
SP No Yes Yes


So when a user selects thput - 60 from drop-down it should check the value in the range if greater than or equal to - in this case it should return all A, B & C. if user selects 160 then it should return B & C

Additionally when user selects THput-60 and PT 70 - then result should return C

 

[Hui]

Where do you want the drop down ?

What are the rules for determining what is returned?

What do you mean by return all of A, B & C?

Can you please describe what you want to do as the above doesn't make sense?

 

[New VBA User]

Hi,

I will place the drop down in another sheet - where the user will select the values.
A, B & C are the model types (in the sample sheet they are specified as 3750, 3650,3850)

Return of All A,B & C means - When user inputs the criteria for one e.g. say thput - it should check the value in the range if greater than or equal to in the master sheet/ database. So it should return the model nos wherever the value is greater than or equal to.

If there are more than 1 condition - then wherever it is numeric value field - it should check for greater than or equal to & then return the results.

 

[Hui]

I am sorry
I am totally confused

can you add some colored and labeled cells to indicate what you require the user to complete
and what answers you require

 

[New VBA User]

Hello,

please see the screenshot. When I enter atleast one of the values - it should compare with the table in Column J to Column M and return the recommended Model No in Cell B10

So when I enter 160 in Cell B2 - it should check for greater than or equal to 160 and give me the results i.e. Model 3650 & 3850.

Hope this clarifies