Hey all,

This is a question I've had for a while, and researched many times without finding a solution (I hope I'm not just missing something very simple). My goal is to lookup a value in a table I have. Specifically, I'm trying to search multiple columns for a value, and return a value from the same row.

Here's an easy example of what I am looking for (see attached): organizing a camping trip. I have a list of cabins, and assigned the participants to each one, based on how many bunks were available in each cabin. I'd like to turn this list into a rooming list that I can sort alphabetically by participant. I'd like to do this by using a search function to lookup which cabin the person was assigned.

ExcelHelp_Table_and_Desired_Results.xlsx

Please help! Many thanks.