Using a formula to search for specific values

[magnum55]

Hi,
This is my first post...

I've got a list of countries (colA) each with a number (colB) in the adjacent column in Sheet 1. What i want to try and do is put a formula/macro in another sheet (sheet 2) saying something like:

look at sheet1, Look through each country name, move 1 cell the right. If this contains a value >20 display the country name in this sheet (sheet2).

I assume that Ill have to name my list of countries as a range and maybe use an IF / VLOOKUP function but I'm not entirely sure....

Any ideas

 

[Andrew Poulsom]

Where is the product name?

 

[magnum55]

Apologies!!

Ive amended the post.

 

[Andrew Poulsom]

Couldn't you just AutoFilter your data for number >20?

 

[magnum55]

I could but i wanted to be able to change one cell which has the value in and this would change my list. Is there a way to autofilter by referencing a value in a cell?

Thanks

 

[Andrew Poulsom]

You could use the Worksheet_Change event procedure to automate the AutoFilter.