This requires DGet function. It's a Database and list management function.
The syntax for DGet function is:
DGET(database,field,criteria)
To turn to your case:
1. You have to create a range to fill the criteria
1.1. Criteria is nothing but the conditions you apply to restrict the result.
Say, x=222, y=Tony etc.,
2. Database is the range where you search results for your criteria
2.2. Remember the both the Database and criteria column headers should be
unique
3. Field is the column value that you want to return (result)
For more help go to Help menu.





"Todd Lietha" wrote:

I posted this earlier, but missed a key element in the example.

How would I do the following using a formula:

Find the row that contains value X, then in that row find the cell that
contains value Y, then return the value to the immediate right?

Example:
111 AAA Todd 2 Tim 4
222 ABB Tony 6 Todd 5
333 BBB Tim 8 Sue 3 Jim 7
x=222, y=Tony, returned value = 6
x=111 y=Tim, returned value = 4
x=333 y=Jim, returned value = 7

Thanks in advance!