Hmmm... That's along the right idea. Check out the attachment... What I would like is for all IDs on sheet 1 to match the three IDs on sheet 2 with the appropriate name. Your formula worked, but when I added more IDs to sheet one, it came back with 'N/A' as the result.
Thank you so much!!!



Example for wblewis935.xlsx