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!!
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!!