Interview Question in Sharepoint 2007


 

Question :: How to lookup a list item using multiple fields w/in a SP Dsgnr wrkflw

I have a case where I need to query a list for an item based on the values in more than one field.  (For example sake, something like Lastname = Jones and Firstname = John)   There may be several 'Jones' and several 'John' in the list.  As far as I've been able to tell, the only thing I can do is search for one or the other and the result will always be the first item encountered.  How can I query a list from within a SP Designer workflow with matching criteria in more than one field?