Setting up excel sheet to 'query' data from table & return info

[cathy2007]

Looking to set up a simple query:

Job Stream: person would key in - let's say "IT"
Org Level: person would key in - 3

Then output would be:
Employee Name: all results from table that match IT AND 3 and higher when looking through table of employee records

Would this be an IF statement, or Vlookup, and what is formula? Can the formula pull IT and 3, 4, 5, etc. from data in a column?

Thank-you!!

 

[rondeondo]

Hi Cathy

there's a process in Excel for building a filter, not an auto filter though that would be an option also, see Microsoft Help for details.

Alternately you could use auto filter and select the job steam value and for the level you can select greater than or equal to

If you want to be able to type in the criteria and have the list appear I think you'd need to go for VBA. The auto filter is a pretty good option. To apply an auto filter, select the columns you want to filter and go to the data ribbon and click filter or press ctrl+shift+L: