Search a query that matches multiple table fields

How to retrieve / output values that match multiple table fields.

SELECT name FROM table WHERE name IN ( 'Value1', 'Value2' );

My search query should take the following parameters : first_name and roll_number in user_table.

e.g. Retrieving a query on the following lines : Roy whose roll number is 5

I need to query this using a single query.